DSXchange

Hi all, Have one question. We have a job which reads sql db and loads into db2 db everyday. Now, can I put any code in transformer which will abort the job if 0 records are there in input file. We certainly can do a code in Job Control to abort it. Anything in transformer as a constraint...? Job A J...

Thanks Craig and Ray. It worked perfectly.

Never mind.. Got it solved... Thanks a lot.. Appreciate as always...

Craig, Thanks a lot. I thought so. We have all the way top to bottom OCON/INCONV floating... lol. Now, I used the below substrings function, which transformer is not accepting. Anything wrong with the "" in transformer. As input is 201302031500, and output is 03/02/2013 3.00Pm.I used, SUBS...

Thanks Craig. Unfortunate I can't see the explanation as my premium membership is still not activated. Its been almost a month gone, have sent lots of emails to admin. Not yet done..

Craig,
I used StringToTimeStamp(Input,"%mm/%dd/%yyyy %hh:%nn:%ss")

Is this correct? In transformer, it is not accepting it. Neither in Stagevariable.

Have one more question again,

Have a job where input is SQL db and output is DB2 db. There appointment date is Varchar,12 in SQL db with the format of 201403021500 which I am trying to convert as 03/02/2014 3.00 PM (Timestamp)

Any help.
Thanks.

Thanks a lot. I changed it.. working fine now....Appreciate your help..

Hi, Need a help on loading four digit code number from SQL to DB2 database. In input SQL db the code column data type is (Varchar,4) and output db2 database it is Integer.

The issue is that, in SQL db if an number is 0837, in output DB2 its loading as 837. Its a straight column mapping.

Thanks.

Thanks Craig. It worked now.

Need one more help. I have four columns, Street,State,City and zipcode. Now, I have an error table where if any of the four values is NULL, it will be inserted as "error001" at the same time the same row (which is in error table) will be inserted in output table with the same error code. N...

No problem Craig. Thanks a lot for your help. Appreciate it as always.
I am having one more issue, have not able to figure out whats wrong in it. I am posting in a different topic. Thanks.

Thanks a lot.. I got it. Its working fine now. I was keep using + while concatenating the statement. So, the final output was 0. When used : instead of +, it worked. Thanks again.

Thanks Craig. I actually can't see the whole explanation as it is locked though I have premium membership. I have sent an email to the editor, hoping it will be solved very soon. Now, NullToEmpty returns an empty string if the input column is null, otherwise it returns the input column value.right T...

Hi, hope everybody is doing well. Need your help. I am trying to load a datastage server job which has one look up table. It structures this way, Address look up------ Input ---------Transformer------Output Now, there is a column "street address" which populates data Add1(varchar,100) and ...