Search found 5168 matches

by kumar_s
Mon Feb 26, 2007 4:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TrimB and TrimF does not remove tab
Replies: 10
Views: 8025

Right now, I dont have access with PX. May be someone else can check in their end and let you know if thats by any chance related to the environment.
by kumar_s
Mon Feb 26, 2007 4:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting the file Logically
Replies: 3
Views: 707

If you know the whole file size and if you know what size you need to split into, you can as well use "Sample" stage with percentage values given.
by kumar_s
Mon Feb 26, 2007 4:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TrimB and TrimF does not remove tab
Replies: 10
Views: 8025

But "they" did mentioned in documentation about tabs. :evil:
by kumar_s
Mon Feb 26, 2007 3:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Calling Sequence name in the routine
Replies: 3
Views: 1260

Try DSJobController in Macro available in Transformer.
by kumar_s
Mon Feb 26, 2007 2:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TrimB and TrimF does not remove tab
Replies: 10
Views: 8025

I noticed that. Giving the condition as "L", "T" in Trim will force for Leading and trailing. As I said, atleast we can get the pattern on its functionality and it will help to get to know on why TrimB and TrimF didn't work.
by kumar_s
Mon Feb 26, 2007 2:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Why dont we have look-up stage in Datastage Server jobs
Replies: 10
Views: 4746

If you are referring to Server jobs, Dataset is not available in Server jobs. :)
by kumar_s
Mon Feb 26, 2007 2:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting the file Logically
Replies: 3
Views: 707

You cannot split based on Size using DS. But you can make use of the OS command in DS. You can use "split" command with the size given as parameter in execute command activity, to split the files into several sub files. Later using FilePatter option available in sequential file, you can merge all th...
by kumar_s
Mon Feb 26, 2007 2:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: uvodbc.config - What is the correct steps for updating
Replies: 2
Views: 1535

Its a configurable file, not required to restart the server.
by kumar_s
Mon Feb 26, 2007 1:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TrimB and TrimF does not remove tab
Replies: 10
Views: 8025

Hmm... what happens when you include the options like "L", or 'T" in Trim.
At least we can come to a conclusion for the reason, for the tab not getting trimmed.
by kumar_s
Fri Feb 23, 2007 5:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job's previous run time
Replies: 4
Views: 895

If you are calling it from dsjob function, you can as well use

Code: Select all

dsjob -jobinfo $Project $Job | grep 'Last Run Time'
by kumar_s
Fri Feb 23, 2007 5:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: difference between two dates
Replies: 3
Views: 1376

Iconv() is widely used function to convert the external format into internal figures.
by kumar_s
Fri Feb 23, 2007 12:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: STP stage
Replies: 2
Views: 679

DSGetJobInfo can be used in a transformer, to pass the status of the job to a STP stage parameters. The rest can be Job Parameters.
by kumar_s
Fri Feb 23, 2007 12:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to Read Decimal Values from a sequential file
Replies: 6
Views: 2815

Try the default value with "00000000000000,000000000000". ie., 0's till its max length.
by kumar_s
Thu Feb 22, 2007 10:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Output datasets via a command line
Replies: 10
Views: 3402

No its the command line utility. orchadmin is an executable available under you PXEngine\bin dir.
Just execute "orchadmin", it will show you the list of options available.
by kumar_s
Thu Feb 22, 2007 4:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: After-job subroutine does not work
Replies: 19
Views: 3586

So its time for you to mark the topic as resolved.