MVSFORUMS.com

[vjkumk]

Hi,i have to get values from a flatfile according to the testcase,my output file contains test case number,data retrived according to testcase.now,i have to insert these to a tableThe table columns and datatype as follows.
testcase number integer type
testcase data char type
i am using a bmcload utility to insert the output file to the table.the problem is the testcase number in the table,my output file contains testcase number in char type,where as in the table is of integer type.is this will casue any change in data?can we use the decimal function in db2,is there anyway in rexx that we can write the ouput file in decmial format?My output file must contain both decimal and char type values.

[Nic Clouston]

have you actually tried it yet to see if you have a problem?
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

[vjkumk]

The table i have to load is a production one,so i feel that it has to be tested before loading data,somehow i got the privilage to create those table under my db2 id.the db2 automatically converts numeric character to integer.the problem is solved on this part.

to write a ouput file,i tried with the rexx function C2D
but it is throwing error when trying to write along with char data
VJ

[arnold57]

You probably need to use function D2C.

For example, D2C(123,4) will result in a 4-byte "integer" with a value of 123.

[vjkumk]

I will make my query clear,
in pl1 and cobol ,there are datatypes like fixed decimal ,as per my knowledge rexx does not have a datatype,it usually uses char type.In pl1 and cobol we can write decimal and char type using structure or pointer to the output file
ex. In PL1
01 out1,
05 name char(10),
05 age fixed dec(5,0);
using the above struc,decimal and char data can be written to output file,is there any way in rexx to write the output file as mentioned above,the single record should contain both char and decimal data.

[kolusu]

vjkumk,

check this link

http://www.mvsforums.com/helpboards/viewtopic.php?p=26661#26661

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu