Search found 5168 matches

by kumar_s
Thu Oct 19, 2006 3:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Schedule
Replies: 11
Views: 2880

Hi Meena,
If you are scheduling at 11.59pm for 12.00am, do it for tomorrow and not Today.
by kumar_s
Thu Oct 19, 2006 3:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RE:Error
Replies: 1
Views: 637

Are you gettin all the error at the same time or in same job?
Or is it all just a question to be know?
Have you checked the config file you have. Use the available GUI tool to check you APT_CONFIG file that been used in your server.
by kumar_s
Thu Oct 19, 2006 3:07 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Difference between DWH Datastage and Datastage TX
Replies: 7
Views: 5715

Hi Ravish,

Welcome aboard :D !!!
You should be refering DSTX to Datastage TX, one and the same.
by kumar_s
Wed Oct 18, 2006 7:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Maximum and Minimum JOBNO in a project
Replies: 9
Views: 2132

Ray - Everytime you give out some new stuff. May I know what 'DET.SUP' used in your query for. Is it to suppress the Description information?
by kumar_s
Wed Oct 18, 2006 7:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Schedule
Replies: 11
Views: 2880

You cannot schedule the job for today at 12:00 am. Unless your current time is 12.00 am. Where the time is alreay passed.
After you press Ok, dont you get any warning or error message?
by kumar_s
Wed Oct 18, 2006 7:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Error
Replies: 10
Views: 3053

zam62 - Do you wish to share, how this issue has been resolved?
by kumar_s
Wed Oct 18, 2006 7:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Missing record delimiter "\n", saw EOF instead
Replies: 22
Views: 38013

Change the Char data type to Varchar.
As character Datatype might expect the fixed size character for the defined length. Since you input seems variable length, there is a chance where new line character may come even before the defined length.
by kumar_s
Wed Oct 18, 2006 7:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Upgrade to 8.0 for Server-only sites
Replies: 5
Views: 1114

This sounds interesting. I ll check whether my site is still convered under maintanance.
by kumar_s
Wed Oct 18, 2006 6:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete one record from file
Replies: 7
Views: 3398

Even what I explained doesn't delete but, just skip.
by kumar_s
Wed Oct 18, 2006 6:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete one record from file
Replies: 7
Views: 3398

You have the first name as column name property in sequential file. Which will eliminate the first line been read.
You can also achive by just counting the total number of records present in the file, and tail of n-1.
by kumar_s
Wed Oct 18, 2006 6:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: encrypted pw from parm file to EE oracle stage
Replies: 15
Views: 5248

Could see the same value been passed to the Password parameter from the routine that calls the job. You can find this by double clicking the job in director on Status View.
by kumar_s
Wed Oct 18, 2006 6:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Importing and Running an Oracle Stored Procedure
Replies: 10
Views: 4800

If you dont have any parameters to pass, you can call the procedure from either Before SQL or After SQL, by just CALL ProcedureName;
by kumar_s
Wed Oct 18, 2006 6:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting jobnmaes
Replies: 9
Views: 1928

It may not be easy to pickup the order from exported file. The of execution of jobs can even changed during runtime or the logic that been defined.
But you can parse the output log file and can get the order in which the jobs been executed by that JobSequence.
by kumar_s
Wed Oct 18, 2006 6:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: trim the row values
Replies: 10
Views: 2313

And if "[" present for all the cases.