DSXchange

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...

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...

IF Index(DecimalToString(decimal_input,"fix_zero,suppress_zero"), '.',1)=0 THEN
DecimalToString(decimal_input,"fix_zero,suppress_zero") : '.00' ELSE DecimalToString(decimal_input,"fix_zero,suppress_zero")

Thanks alot

Thanks alot...I'm really thankful to you. And last question is there any function available in transformer based on the pattern search to split the record

Hi ray, can u kindly explain me which stages should i use.... using transformer stage or restructure stages?

Thanks for helping me

Thanks ray... let me try it

Hi ray, Yes it is precisely 2 alphabets followed by the number. Not yet decided which job should I go, Plz let me know how to do it

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...

Hi craig, Sorry abt it... from next time onwards I will correct it.As of now, the data which i came across got 10 columns, but it is variable data ... it may go more than 10 columns also

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...

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

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....

Can someone tell me how to read data from MQRFH2 messages using MQ connector stage??

You can use the @inrownum function in the transformer and output the result to a flat file or a table