DSXchange

Hello all Im trying to get the previous date from the below derivation StringToDate(trim(DSLink6.end_serv_date),"%dd-%mmm-%yy")-1 here link DSLink6.end_serv_date is a varchar type while im trying above im getting the compilation error as Error in output column derivation expression for col...

Hello Ray

Can you Please Share your knowledge Hw Modify stage handle leading and trailing Space ..

Iam asking Trimming of the Data.

Thanks in Advance

Hello

Can any one share your Knowledge On Hw to Trim the Data in a Filed
using Modify Stage

Thanks in Advance

Thanks Kumar

Now it's working
The problem was even though the fields were having the same size there was some trailing spaces

i have done trim function..now it's working

instead of trnasformer im going to use the Modify stage..let's see hw it will work

Hi Kumar Im Using inner join on Mobile_Number which is Varchar(15) in both files and im doing hash partetioning on Both It seems to be correct what you said on Trim But my sources to the Join Stage are Sequential files Can you please tell me hw to do the Trim on Seqential file column which are direc...

Hello All I have Two Sequential files Iam Joining these two Files Using Join Stage based on the Key Column Which is a varchar..im Using the same column name to join these Files It getting compiled but ..During run time no value is Coming out of the Join Stage I have tried with to search the Forum bu...

Just check whether the same table is not existing in u r database or else put the table name in uppercase

Hameed

Hi balaji

i want to know some thing more about u r suggestion ..r u coming coming up with any measure so that moderator can judge whether it is worthy to put on ...if don't ??? then y u have this suggestion ??

Hello all

i would like to get documents about datastage MVS edition .... i have searched but got some information only

can any one give me an idea where can i get the full details of MVS edition functionality...i did serach in IBM site ..but i haven't get more details


Thanks

Arshad

Thanks Ray for reply

Will you please give some more information how ds xe/390 will handle the packed field/column

Thanks a lot

Arshad

Thanks Ray for reply we have a mainframe source in that we have comp-3 field and it is going to be landed in to unix..in our discussion and came to know that the packed field will get garbage values when it landed in to unix.actually we are looking to know how ds xe/390 will handle mainframe data. c...

Hello All

can any one please provide me isome nformation on xe/390. i would like to know benifits of using xe/390, compared to PX and Server edition.

as Iam new to datastage it would be great help.

Thanks

Arshad

Hello I have a file which is genarated on Mainframe.(is there any special method to for generation like Binary file).. after FTP the file landed to my unix machine can any one tell how to handle the packed filed in while i am using in datastage PX ....will complex flat file able to handle ?? can any...

Hello


Any one can please tell me that how to handle mainframe data which is going to be landed on the unix

Any best practices ?

Thanks in Advance

Arshad