DSXchange

I should be resolving this issue without changing the metadata of the columns since the job is fine in production .This runs daily in production! well something u gotta change to get it working right? try trimming it.. from the error it seems there is issue with function and decimal o/p value it se...

The metadata is set properly.The job is currently running perfectly in the production.The prob is with dev only...! :? sometimes slight changes in dev / prod environments creat such minor issues mate...if u are not performing any calculation on decimal col. I would change it as string and try to pr...

shalini11 wrote:Try this

If Trim(DSLink1.okcucl[1,1])='5' Then '020':Trim(DSLink1.okcucl[2,len(DSLink1.okcucl)])
Else If Trim(DSLink1.okcucl[1,2])='65' Then '030':Trim(DSLink1.okcucl[3,len(DSLink1.okcucl)])
Else '001'

mate...perfect answer!

Hi guys, The problem has been resolved. It was padding with space issue itself. Dont know why ltrim and rtrim didnt work, but when i did 'REPLACE(Some_Field, ' ', '')' it gave me proper distinct records. Thanks a lot to all! ecjjactly...mate...when you have distinct issues you have improper sql for...

Thanks for the reply. I want to track the filename of the each file being processed in datastage director. mate dodda...whats the issue in tracking the filenames in director? doesn't director gives you a running log of everything? :roll: else mate...dodda... us peak stage and tune it as per your ch...

I have to load data from a file into database. When there are no records in the file(empty file), then i want to enter 1 hardcoded record into table. mate...since you have not described the scenario properly, how your job is going to run properly. if at source level file if there is no data, won't ...

dnat...master...can't you use any unix / shell script to remove and clean quotations issue... that should be fairly resolve it

Moreover datasets are bound by the no. nodes you had used during partitioning or processing... there may be 4 or more such nodes that the dataset is distributed over... so how can you read such files?

create a job that reads datasets and gets you either seq. files or xml files as output and then thru. your java prog. u can read those... am I right?

K3486... dude have you created any transformer stage variables...? Make sure to use proper datatypes for them and set proper metadata too in transformer

B'cus I need to read the log files and send out information to mail.

What you want to read in log files and what you want to send mail for? Pls. describe.

In Datastage Director tool you can output job log into text file and use that text file to mail it yourself...

Try to set the metadata for decimal column properly...

How can an individual become IBM partner? Can you please suggest sites on that and to avail the "education Value Pack"?

calculate the total no. of days and run loop activity counter for total no. of days that you get. That may solve your issue.

I see comparisions of Lookup and Join in several discussions and in the manuals. I think one of the fundamental differences is the inability of Join to provide multiple output streams (one output and one reject) whereas Lookup stage provides for this functionality. If I am getting you correctly, th...