DSXchange

Hi,

Actually i mentioned in my post that i want to retain 1st value...

Hey all, I am having a lookup file which is fetched from an ERP system at the run time and is directly fed to the hash file and is used as a lookup. Th problem is there are sometimes duplicate lookup parameters in the lookup file for a single value to be searched. for e.g. in my master file "CC...

Hi,

I tried with column wise settings by checking Incomplete column and contains terminator options, but still it throws an error saying, "Column can not retain incomplete data as it is a delimited file"

ArndW wrote:How about using the attribute for "incomplete column"? ...

Hi ArndW,

Can you please tell me in an elaborated manner, sorry but i did'nt understand.

thanks

Hi All, I am having a funny problem in reading a source file in my DS job. Actually the source file is '~' delimited. In the file last column is having null in all the records, not even spaces. Now datastage is not reading that column and throwing "Read File Delimited" error. can u please ...

If number of iteration is know, the job can be made as multiple instance and individual parameters with different values can be passed. Actually in my case, the no. of iterations are not known. there is a column in which date is comming as and i check for month in that date. if the month is new and...

I have a job where both input and output are sequential files with the same column definitions- file1 ---->Tfr ----> file2 How can I run this file multiple times (say 10 times), one after the other such that in every other run, the 2 files switch their names? That is, if the above shown design is m...

Hi all,

Thanks for the help, now i got many possibilities to write a routine effectively

Unfortunately if you wish to use INDEX() you will need to do some sort of a loop, checking the string for each substring in your list sequentially. The DataStage pattern matching mechanism will wo ... Hi Arnd, What you are saying is my concern, that's why i am seeking any single line function. Sorr...

Hi all, I need to check the incomming source data string of a column, for words like ELEC, GAS, & CONS. The data is comming as ABC ELECTRICALS, Cooper GAS works, etc. currently i am using VarIndex = index('ABC ELECTRICALS','ELEC',1) If VarIndex <> 0 then Ans = 1 else Ans = 0. , but for above men...

I am looking for a way to pass parameter value out of a server job to be used as value in parameter of another server job. I realize that this is not possible to do easily and I don't want to put a value into hash value and then retrieve it using UtilityHashLookup in sequence job. I was thinking to...

Hi Satheesh, 'No there can not be extra spaces as the file is a delimited file and the delimiter is '}' . ' Hope you have you noticed this? Hi Kumar, Even in the delimited file spaces can come. I am handling all the source files those are '~' delimited. This is a small part of my data. where length...

No there can not be extra spaces as the file is a delimited file and the delimiter is '}' .[/quote]

Hi,

My source file was also '~' delimited, but when you define the metadata, then if the spaces are there with the data between delimiters then those spaces also come in with the data.

Archana, a hashed file key is unique. If you specified all 3 key columns when you wrote to the hashed file you cannot have duplicates. Are you certain you specified all 3 columns as keys for the hashed file? If you are certain, could you show an example of a duplicate record? Hi Archana, I also had...

Hi,

i had downloaded a C algorithm for image compression from the net and trying to implement it in the datastage routine, currently i did'nt get any success but i am trying to rewrite that algorithm in BASIC format.