Search found 6797 matches

by DSguru2B
Tue Jan 02, 2007 7:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: reject rows thru column derivation
Replies: 7
Views: 5613

Re: reject rows thru column derivation

DSbox61 wrote:I saw an option in column derivations, under Link Variables which says REJECTED....



That statement assures that it is, infact, a server job type and not px. He/she just posted in the wrong forum.
by DSguru2B
Tue Jan 02, 2007 7:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Adding a new column
Replies: 8
Views: 2739

Munish wrote:Yes, thats what I am using.
But my value is just one fixed number say 1 (numeric)
I am strugling to fill that column with that value (1).

Thanks

Thats a confusing statement. Clarify please, else we will just be guessing.
by DSguru2B
Tue Jan 02, 2007 7:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: HowTo extract data from binary file?
Replies: 15
Views: 4933

Seems like a dos file with that box character before date. Try to convert it to unix style or try to read it as a dos style file. How are you getting this file. If its being ftp'd directly from mainframe, then request them to transfer it in ascii so that the conversions are made for the appropriate ...
by DSguru2B
Tue Jan 02, 2007 6:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file cache size error
Replies: 2
Views: 614

This has been covered time and again. Search on the keywords 'add_to_heap()'.
by DSguru2B
Sat Dec 30, 2006 9:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Table Name from selected Column
Replies: 5
Views: 1268

I guess i missed out on your last para. Aplogies....
Well no damage done, just re-inforced your advice :wink:
by DSguru2B
Sat Dec 30, 2006 4:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Function to Replace a string with replacement string ?
Replies: 11
Views: 6258

Thanks for the clarification. Could'nt remember.
by DSguru2B
Sat Dec 30, 2006 2:20 pm
Forum: General
Topic: Happy New Year, 2007.
Replies: 16
Views: 6135

us1aslam1us wrote:obfuscatory='confuse or unclear'. This is tough guys......

Sam

Craig has joined Wurlord's club. :wink:
by DSguru2B
Sat Dec 30, 2006 2:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: fatal error because of partitioning
Replies: 4
Views: 1798

Do an exact search on the keywords 'There are irreconcilable constraints'. This has been discussed here before.
by DSguru2B
Sat Dec 30, 2006 1:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Function to Replace a string with replacement string ?
Replies: 11
Views: 6258

EREPLACE() is not present in PX ??? I cant remember. I know Convert() function is present. Otherwise its not hard to write a C routine to do this.
string.h library in C has a lot of string functions. You can google it up.
by DSguru2B
Fri Dec 29, 2006 10:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Exporting nullable field
Replies: 2
Views: 1366

The error message tell you all. Null values are being passed. They need to be handled, explicitly. As narasimha mentioned, search for ways of achieving that.
by DSguru2B
Fri Dec 29, 2006 4:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: A Value Search in a String
Replies: 9
Views: 3564

I_Server_Whale wrote:Well! If you are really looking for an answer. Then,

Code: Select all


i  <> I ,  Where 'I' refers to the nominative singular pronoun, used by a speaker in referring to himself or herself. .

:wink:


Cute. I was referring to the proverb :wink:
by DSguru2B
Fri Dec 29, 2006 4:10 pm
Forum: General
Topic: Happy New Year, 2007.
Replies: 16
Views: 6135

Dont do that, or we will have to guess what you are trying to say... We need your verbosity here :wink:
by DSguru2B
Fri Dec 29, 2006 4:09 pm
Forum: General
Topic: odbc
Replies: 41
Views: 15395

Check it while importing odbc table definitions. Can you see it in the pull down menu there ?
by DSguru2B
Fri Dec 29, 2006 4:07 pm
Forum: General
Topic: Happy New Year, 2007.
Replies: 16
Views: 6135

Is that your moto too, for 2007 :?:
by DSguru2B
Fri Dec 29, 2006 3:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: many records to one
Replies: 7
Views: 2020

Search my friend search. Its not that hard...