Search found 131 matches

by shilpa79
Fri Jun 15, 2007 4:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: I/p file name should be same as O/P xml file
Replies: 0
Views: 473

I/p file name should be same as O/P xml file

Hi, I have designed the Job in server before getting the I/P file name as the O/P file name using shell scripts. Now I would like to re-dsign without using the shellscipts. My design is :( I am just testing i donot whether its going to work or not) External source stage -----> xml I/P-------->Xfm --...
by shilpa79
Mon Jun 04, 2007 12:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reset the Job
Replies: 7
Views: 2964

WHY use Execute Command activity to invoke dsjob command ?!!!!! Use a Job activity. You can then use "reset if required, then run" as its mode of operation, and everything is automatic. No ... I was using Execute command instead of Job activity because I need to process mutiple files and ...
by shilpa79
Fri Jun 01, 2007 11:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reset the Job
Replies: 7
Views: 2964

The error messages look odd. What options are you using when calling the job from the sequence? Have you thought about using the "reset then run@ option so you don't need to explicitly reset the jo ... My Job design is from the execute command stage using the dsjob command I am calling the dsj...
by shilpa79
Thu May 31, 2007 4:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reset the Job
Replies: 7
Views: 2964

What is causing the abort in the sequence that tries to reset your failed job? Could you post the error message that is generated? sequencer log: JobControl (fatal error from @Coordinator): Sequence job will abort due to previous unrecoverable errors dsjob log: Attempting to Cleanup after ABORT rai...
by shilpa79
Thu May 31, 2007 1:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reset the Job
Replies: 7
Views: 2964

Reset the Job

Hi, I am trying to reset my Job if the Input XML file is in incorrect format and not processed properly and nothing is loaded into the target DB then i am moving those files to unprocess folder where I am using a shell script to move the files from inbox to unprocess directories. I am using a routin...
by shilpa79
Mon May 07, 2007 1:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup stage
Replies: 1
Views: 686

Lookup stage

My source is XML file and I am doing lookup to pull the ID joining the creation date but I need to get the max(ID) and when I am trying to use this User-defined query from RDMS stage its not working.................. SELECT Max(schema.tblname.DocumentID),schema.tblname.Created FROM schema.tblname WH...
by shilpa79
Mon Apr 16, 2007 5:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convertions
Replies: 21
Views: 19943

i am working another deisgn again dates probelm. :shock: Sql server dates into orcale both are timestamps in source and target and I chnaged the sql types of source columns and given as varchar and able to view he data . In the transform used the stringtotimestamp function for conversion error: Conv...
by shilpa79
Mon Apr 16, 2007 5:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convertions
Replies: 21
Views: 19943

us1aslam1us wrote:Good for you. But why SUM? Is that in your requirement. :roll:
yes, they wasnt sum of invoice quantity for the same invoices

Its still throwing me the same error.

Thanks,
by shilpa79
Mon Apr 16, 2007 4:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convertions
Replies: 21
Views: 19943

chulett wrote:You really want to suggest they CAST the INVOICE_QUANTITY to a date? :wink: ...
Invoice_quantity is not date column .

I tried using like this in the sql....
sum(cast(inv.invoice_quantity,decimal) invoice_quantity

Let me know if I am on the right path

Thanks,
by shilpa79
Mon Apr 16, 2007 3:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convertions
Replies: 21
Views: 19943

NOW ATLAST DATES ARE WORKING FINE .
I USED CONVERT FUNCTOIN AND IT WORKED

Thanks for all your help ......................................
by shilpa79
Mon Apr 16, 2007 2:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convertions
Replies: 21
Views: 19943

us1aslam1us wrote:Try to use cast function and read that as a varchar.
For invoice date column its varchar in source and target . I would like to change just the format 04/13/2007 to 04-13-2007.


Thanks,
by shilpa79
Mon Apr 16, 2007 10:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convertions
Replies: 21
Views: 19943

[2. Change AMOUNT field as decimal(38,10) both in source and target.
[/quote]

If I give decimal(38,10) for the source column it giving me as
00000000000.00

Thanks
by shilpa79
Mon Apr 16, 2007 10:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convertions
Replies: 21
Views: 19943

Thanks for all your inputs. I will try them and get back to you......................
by shilpa79
Fri Apr 13, 2007 6:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convertions
Replies: 21
Views: 19943

1)As wht dsguru said I increased the INVOICE_QUANTITY column length to 17 Source sample data :" 000000000007601" source sql type is Varchar(15) ----- Xml Varchar(17) Error1:INVOICE_QUANTITY floating point decimal is not fully supported; adjusting the scale. Error2:When checking operator: W...
by shilpa79
Fri Apr 13, 2007 11:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convertions
Replies: 21
Views: 19943

Not all conversions are automatic as in server jobs. Your mindset is still on server jobs - you even marked this as a server jobs. The error message codes indicate that it isn't. You need expli ... No, I am not designing this Job in server its a PX job. I tried with the above results still while co...