DSXchange

taking your values into consideration with DECIMAL(length=38 and scale=15), writing values in sequential files gives answer as 765061.638.

marking other columns as key marks these keyed column to be used for where condition in update clause by oracle stage

and these parameters what ray has said can be set values through DSSetParam.

column terminator can be found in column tabs in sequential file.

link variable DBMSCODE. can help you, but regarding description of each oracle error is little tough.

hello, i have used oracle datatype numeric format example of precision and scale, for example column A(length=5,precision=4) value=8.0000 column B(length=6,precision=4) value=21.4300. and i am getting values as 171.44. (Length=15,scale=2) with other formating of numeric fields, it works fine. please...

i have the same environment as your requirement ORACLE on HP-UNIX and datastage on Windows-NT, it works fine as said by chulett .

hello ray i am extremely sorry for my multiple posts, some problem with sessions.

if you are well aware of how many columns are their for your parent and child records, just like 7 columns for parent records and 12 fields for child. then you can use sequential file stage to read your .CSV file and putting constraints in transformer stage you can Segregate out your parent and chil...

if you are well aware of how many columns are their for your parent and child records, just like 7 columns for parent records and 12 fields for child. then you can use sequential file stage to read your .CSV file and putting constraints in transformer stage you can Segregate out your parent and chil...

if you are well aware of how many columns are their for your parent and child records, just like 7 columns for parent records and 12 fields for child. then you can use sequential file stage to read your .CSV file and putting constraints in transformer stage you can Segregate out your parent and chil...

yes it will create a unique number everytime you execute your job.

hello if your input parameters are fixed, say in number 1,2 ...3 or more, but thier values are stored in text file then, you can do is in JOB CONTROL use following

DSSetParam
DSRunJob
...DSDetachJob

you can read your file and set values for parameters using DSSetParam.

hello if i have understood your requirement well then, i think you should know what all lookup's you need like product...or something else. then... in server jobs you can have your input file ---- transformer(constraints) ---> output(1,2...3). in transformer stage you can put constraints and get val...

i agree with ray.