DSXchange

Hi Titto, You can use the below transformation and tell me whether it works for you. Oconv(Iconv(Read.Date,"D2/"),"D-YMD[4,2,2]") Heather, As far as I know, there is no standard function in Datastage called DateIconv, if it is, please let me know where I can find it. I am assumin...

Hi Balaid, Like rumu pointed out rightly, you can not use any of the techniques mentioned above to merge your source files, if they have differernt structures. I have three table structures with different column names each. I want to join those three tables/files using some stages. can i join using ...

Hi Krish,

It would be helpfull for us to advise you, if you tell the exact error you are getting.

Thanks a lot for the reply ArndW :D

The Perform guide contains the list of all commands you can execute from the DataStage Engine.

Hi ArndW,

In the link that you provided, there is no guide by the name of perform guide. Could you please let me know the exact name of the PDF document link that you are talking about?

If you always have the same number of input files to be merged, you can even use the link collector stage to first merge all the individual files into one big file and then process that big file. If the number of input files changes dynamically, then it is better to use cat or type commands in a bef...

Hi snassimr, I guess that elavenil meant that, once you see the generated code in either server job using add job or in job sequencer on the job control tab, you can copy the code to a batch job and add your custom code in it. Then you can use the batch job from the command prompt to run the sequenc...

Hi dsx,

Yes, there are stages called XML Input, XML Output, XML Transformer under the Real Time category, which will allow you to extract the data from the XML files.

Hi Studyguy, The Basic Transformer is even present in parallel jobs, Please refer to this thread, if you dont see it in you pallette http://www.dsxchange.com/viewtopic.php?t=86847. That being said, the Basic Transformer will have some negative impact on your jobs performance, as it has to run in seq...

Hi studyguy2001, You can achieve it 1) If you use the Basic Transformer in your job, you can use the below the transformation FMT(InLink.Col1,"10'0'R") Alternatively, you can use some custom logic to check the length of the field and see how many digits it is less than 10 and concatenate t...

Hi Jlock, To get the count of lines in the file, you have two approaches. 1) After you open the file in your routine, loop through the file and keep incrementing a counter, that will give you the number of lines 2) Alternatively, you can use the UNIX command "wc -l" using DSExecute in your...

Thanks for all of your suggestions. The reason I am trying to implement the above logic is as follows. In Branch 2 there is some processing logic, at the end of which I am storing some values in a file. In Branch 1, there is some processing logic, which requires the routine to read those values stor...

Hi NaveenD,

As Arndw already pointed out. /Q switch in Del command, suppresses the confirmation message when deleting mutliple files using wildcards.

Hi Guys, I have two links in my datastage jobs, I want the link1 to start execution after link2 has finished completely. L1 ---> TR1 ---> L4 ---> Tr2 ---> L7 | v L2 | v TR3 | v L3 The branch L2,L3 should be finished before the branch L4,L7 starts executing. I dont want to again split it into two job...

Hi NaveenD, Why dont you use a simple batch script and call it in the before stage?. The batch script can be something like this type file1.txt file2.txt file3.txt > bigfile.txt del /Q file*.txt If your standardize the file names, it will be much simpler to make use of the wildcards in your batch sc...