scottklement.com

Good morning!

I have a web program that allows a user to upload a file to the ifs. Then it does a CPYFRMIMPF to put the data into a temporary file for validation and processing.

What is the best way to attach the user to the records they uploaded?

Hopefully this makes sense!

Below is what I'm ...

Good morning, Scott!

Is there a way to get epoch time via DB2?

Thanks,
Trent

Thanks for all the help, Scott! I appreciate it!

This is strange...

It's cutting off the first 4 characters from the front of the json when it copies data from buffer.

It should start like this.

{
"payorId": "company[09]",

Thanks Scott! That worked!

Would you recommend doing anything different before I put clob data from buffer into the HTTP POST?

Program compiles correctly but I'm getting an SQL state of 01004 once it tries to POST data.

dcl-s JSONDataLength int(10);
dcl-c ToCCSID const(37);
dcl-s jsonData ...

Sweet! I've been able to get this to work using yajl_copyBufStr()!!

I would like to be able to use the yajl_copyBuf function.

When I change my code to use the yajl_copyBuf function. I receive the error below.

Any ideas on what may be causing this?

dcl-s JSONDataLength int(10);
dcl-c ToCCSID ...

Scott,

I really appreciate your help! I've got one more question for ya!

I'm moving the data from the copyBufStr function into a clob variable.

Once I try to use the clob variable inside the SQL statement I get the error below.

Length in varying-length, LOB, or XML host variable not valid ...

Scott,

My goal was to hopefully be able to use the data from the buffer in SQL/HTTP functions.

SQL Webservices has a 32k variable size limit as far as I can tell.

I would like to send more than 32k when using the HTTP post function.

EXEC SQL
SELECT RESPONSE_MESSAGE, RESPONSE_HTTP_HEADER ...

Scott,

I'm having trouble getting the yajl_copyBuf function to work. I've pasted some of my code below.

Do you see anything wrong with what I'm doing? Just to verify that the buffer was getting populated I tried using the yajl_copyBufStr and it works correctly.

dcl-proc Get_Buffer_Data;

dcl-s ...

I figured it out Scott! I didn't realize that the parms had to be defined the exact same way.

I'm now able to successfully write Json created with YAJL functions to IFS directory.

Thanks,
Trent