query continution in spufi input file

sathiyendran.erulan · New User Joined: 04 Mar 2009 Posts: 11 Location: chennai

In SPUFI input file size is 80 bytes per line, i want to update a table that field contains 100 bytes long. It goes next line of the input file. how can i achieve this updation ?

Example :
UPDATE TABLE
SET CMNT_FLD = ‘100 BYTES VALUE’
WHERE CMNT_FLD = 'XYZ'

Raghu navaikulam · Posted: Tue Jun 16, 2009 3:49 pm

Hi sathiyendran.erulan

Try yourself by giving the 100 character long table name. Now the table name can have upto 128 charater long with 80 byte SPUFI program.
So continue the name without a break. After column 72, go to the next line and start from the first position.

Regards
Raghu

sathiyendran.erulan · New User Joined: 04 Mar 2009 Posts: 11 Location: chennai

how we continue the query in next line in spufi ?

Craq Giegerich · Posted: Tue Jun 16, 2009 4:18 pm

enrico-sorichetti · Posted: Tue Jun 16, 2009 4:23 pm

the input is free form, no need to fill the lines, just terminate each statement with a semicolon ;

publib.boulder.ibm.com/tividd/td/ITAME/SC32-1131-01/en_US/HTML/am41_install200.htm

Raghu navaikulam · Posted: Tue Jun 16, 2009 4:23 pm

Thanks Craq Giegerich

You have answered the query.

Regards
Raghu