Search found 15 matches
- Thu Dec 09, 2010 9:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Question on PX lookup
- Replies: 3
- Views: 2399
Whenever using the lookup, its better to use trim function and do lookup on the same datatype.... We faced a problem recently using lookup ... Our source is char(1) and lookup is varchar(1).... when is the number or character, lookup is successful and when there is a space in the source and there is...
- Thu Dec 09, 2010 9:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Look up - Condition Not met - Options
- Replies: 6
- Views: 7575
As far my understanding, lookup will check the source data with lookup data and returns value to target... when you give a condition in the lookup, it will only check the source data which statisfies that condition and returns the lookup value and which doesnt satisfy that condition, it directly pas...
- Sat Nov 20, 2010 2:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: remove leading zeros in decimal field in sequential file
- Replies: 26
- Views: 79547
- Tue Aug 31, 2010 8:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parsing of string
- Replies: 14
- Views: 7684
- Mon Aug 30, 2010 9:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parsing of string
- Replies: 14
- Views: 7684
- Mon Aug 30, 2010 3:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parsing of string
- Replies: 14
- Views: 7684
- Sun Aug 29, 2010 4:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parsing of string
- Replies: 14
- Views: 7684
- Sat Aug 28, 2010 8:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parsing of string
- Replies: 14
- Views: 7684
- Sat Aug 28, 2010 3:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parsing of string
- Replies: 14
- Views: 7684
Hi Craig,thanks for the quick reply... I'm getting the input row in this format it contains 2 alphabets followed by numbers between 1 and 7 and again 2 alphabets followed by numbers between 1 and 7. Now I need to parse this input into several output rows in this format 2 alphabets followed by each n...
- Sat Aug 28, 2010 10:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parsing of string
- Replies: 14
- Views: 7684
- Sat Aug 28, 2010 12:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parsing of string
- Replies: 14
- Views: 7684
Parsing of string
Hi I'm new to the data stage, I had this requirement. Input field is coming from DB2 Input fields AB123JK45 RF45TJ5678 FS245 Now I need to split each field like this AB123JK45 into AB 1, AB 2, AB 3, JK 4, JK 5 RF45TJ5678 into RF4,RF5,TJ5,TJ6,TJ7,TJ8 FS245 into FS2,FS4,FS5 Any Help is highly apprecia...
- Wed Jun 23, 2010 11:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem in reading special characters ,while reading from MQ
- Replies: 1
- Views: 1787
Problem in reading special characters ,while reading from MQ
Hi,
I am reading a file from MQ and place in a sequential file.
I am unable to read special characters (eg: registered trademark)
Is there any property in MQ connector to set, for displaying the special characters correctly.
Thanks
I am reading a file from MQ and place in a sequential file.
I am unable to read special characters (eg: registered trademark)
Is there any property in MQ connector to set, for displaying the special characters correctly.
Thanks
- Wed Jun 23, 2010 11:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Read a file with a delimiter as string
- Replies: 8
- Views: 6003
That would be a problem,if the source data have | character. A minor detail you failed to mention in the original post. I would suggest using the Field() function like you were for a single character, say the pipe as the field delimiter, and then strip the extraneous second character from the field....
- Wed Jun 02, 2010 10:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read data from MQRFH2 messages using MQ connector ?
- Replies: 1
- Views: 2434
How to read data from MQRFH2 messages using MQ connector ?
Can someone tell me how to read data from MQRFH2 messages using MQ connector stage??
- Tue Nov 10, 2009 2:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to access DB2 Counts in a job
- Replies: 2
- Views: 2007
Re: how to access DB2 Counts in a job
You can use the @inrownum function in the transformer and output the result to a flat file or a table