Search found 152 matches
- Tue Feb 03, 2009 4:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem using Convert in Transformer
- Replies: 31
- Views: 12150
- Tue Feb 03, 2009 4:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem using Convert in Transformer
- Replies: 31
- Views: 12150
- Tue Feb 03, 2009 3:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem using Convert in Transformer
- Replies: 31
- Views: 12150
- Tue Feb 03, 2009 3:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem using Convert in Transformer
- Replies: 31
- Views: 12150
- Tue Feb 03, 2009 3:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem using Convert in Transformer
- Replies: 31
- Views: 12150
Re: PXEreplace
did you fill in all the options correctly when creating a routine in the designer??
- Tue Feb 03, 2009 2:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: When should I use "Entire" partitioning in a looku
- Replies: 6
- Views: 2237
Re: lookup
i don't think any
- Tue Feb 03, 2009 2:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem using Convert in Transformer
- Replies: 31
- Views: 12150
- Tue Feb 03, 2009 2:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: When should I use "Entire" partitioning in a looku
- Replies: 6
- Views: 2237
Re: lookup
no it is not mandatory
- Tue Feb 03, 2009 11:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameter Sets
- Replies: 3
- Views: 2533
Re: Parameter Sets
[quote="rjhcc"] Will the user variable be available to all jobs?
Thanks....[/quote]
yes.
you can map the variable in user variable stage to all the job activities/sequences in the sequnce
Thanks....[/quote]
yes.
you can map the variable in user variable stage to all the job activities/sequences in the sequnce
- Tue Feb 03, 2009 9:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Handling date in a sqeuence
- Replies: 6
- Views: 2246
Re: Handling date in a sqeuence
once the parameter is passed to the job, where do you want to calculate the previous day for that date?? in a transformer??? or in a where clause??
- Mon Feb 02, 2009 3:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem using Convert in Transformer
- Replies: 31
- Views: 12150
Re: Transformer
[quote="kittu.raja"][quote="betterthanever"]search the forum...you will get lot of info on this[/quote] I searched the form by replace a string, but I did not get the right one.[/quote] check this http://dsxchange.com/viewtopic.php?t=106358&highlight=pxereplace&sid=0fa9fd...
- Mon Feb 02, 2009 3:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem using Convert in Transformer
- Replies: 31
- Views: 12150
Re: Transformer
search the forum...you will get lot of info on this
- Mon Feb 02, 2009 2:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem using Convert in Transformer
- Replies: 31
- Views: 12150
Re: Transformer
convert function does not work the way you are understanding...
it does not look for a string and replace it with the string you give...
but looks for the character by character
meaning for ex:
if you say convert('ab','cd',link.col)..
it replaces 'a' with 'c' and 'b' with 'd'...
it does not look for a string and replace it with the string you give...
but looks for the character by character
meaning for ex:
if you say convert('ab','cd',link.col)..
it replaces 'a' with 'c' and 'b' with 'd'...
- Fri Jan 30, 2009 1:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Wait for file
- Replies: 7
- Views: 2751
Re: Wait for file
[quote="vinothkumar"]Even I keep any dummy file in that location to test, it is not working. If we give exact file name in Wait for File stage it is working.[/quote]
since it searches for the name of the file name literally...that is why it is waiting...
since it searches for the name of the file name literally...that is why it is waiting...
- Fri Jan 30, 2009 12:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Wait for file
- Replies: 7
- Views: 2751
Re: Wait for file
[quote="vinothkumar"]I gave full path. Instead of giving file name I gave *.*.
But it didnt work..
I gave xx/xx/*.*[/quote]
i presume that you compiled the job and ran the job so that the job waits till any file available in the specified path
is that what you are doing???
But it didnt work..
I gave xx/xx/*.*[/quote]
i presume that you compiled the job and ran the job so that the job waits till any file available in the specified path
is that what you are doing???