DSXchange

Use substring function

Yes, in my job i have a one source file one transformer one target file and two hashed files(same hash used twice for read and write). i have a two fields say A,B,C coming from my source and in my hashed file having two fields A , D(Populating from B with some transformations) and E (Keymngmt ID) . ...

yes, i tried to set optin preload file to memory is disabled, even though its not working,
and also that record level read option is disable for me to check

Hi ray,

Where can i set this option lock for updates, am not able to see your reply fully.

Update action for both options clear before file backup existing is unchecked

Hi, i used a same hashed file in my job twice one time for referring and one time for writing, but issue is what ever records write into hashed file , same records records are not referring at same run , next run only thise records used as reference, but i have to use the records as a reference what...

Thanks for respond, am not supposed to use field function for this scenario because Source 6/1/2010 0:00:00 am getting o/p 2010-6-1 but i need 2010-06-01, so i used Conversion function to handle this . its failed for this format (6/1/2010 0:00:00) dates, when i fetch first ten characters its getting...

Hi

am going to convert the data from D/MDY(Time stamp) format to D-YMD date format using below syntax
OConv(IConv(Arg1[1,10],"D/MDY[2,2,4"),"D-YMD[4,2,2]")
But its failed for below dates.
06/1/2010 0:00:00 because its having data part as 8 characters.

any suggestions???

Server job

Hi,

How to find all characters in a string are numeric???

Any suggestions??

inrow num it doesnot give count the number of records

i need this count in a same link, lets mf src file have two fields A and B, then tgt contain three fileds A and B And C, aditional field contains Count of records passing on that link.

In aggregaator is possible to count number of records in a link??

Thanks for respond, i need to find count of records in a datastage server job

Hi ,

How to get a count of records in a file and process this count to next stage.