DSXchange

Hi all,

DEFFUN ConvertMonth(Arg1,Arg2) calling "DSX.ConvertMonth"

I want to use the inbuilt Routine "ConvertMonth" within my routine to find the Last Day of the month. I use the above stmt. in my routine but that doesn't seem to work.

any changes required.

thanks
Sonia

sorry. fixed the same. It was a control break problem. Thanks anyway.

The after job routine runs after the processing of the container is done.

Hi, Thanks for the reply. But now I have another issue :cry: This routine to append "FIN' to the End Of File is called as an After Job. The File is created by a container in the job. My routine works fine with a simple job but does not seem to work in the one that has the container. Now the que...

Hi all, ErrorCode = 0 Loop ReadSeq FileLine From FileVar On Error Call DSLogWarn("Read Failed ":InputFile:" status= " :Status(),MyRoutine) GoTo ErrorExit End Then End Else Call DSLogInfo("EOF reached " :InputFile:" status= " :Status(),MyRoutine) ErrorCode = 0 ...

Oh! wow! great and simple solution. It worked.

Thanks.
Sonia

Hi, I get a source flat file which has "," delimited data in one of its column which need to be sent as seperate rows. There is no telling how many of such delimited data would come in the column. That is even though there are 8 listed here this no. could vary. "03485,03489 , 03490 , ...

hi Ray,

well this is not a DW kind of environment. We use DS as a bridge between two systems. one system sends me the source file and i send the data to the next system as a flat file. Even though I would like I have no Database to get the "DATE" data from.

thanks and regards
sonia

then do you think you would be able to get the date part correctly. I had to write logic to decide whether i have to use 90,91,92 days based month and leap year.

Hi, I need to roll forward Date1 till it crosses Date2 based on a frequencies (Monthly, Bi yearly, Quarterly etc.) eg Date1 = 01/01/1997 Date2 = 09/30/2004 Frequency = Monthly Forwarded Date = 10/01/2004 Date1 = 01/01/1997 Date2 = 09/30/2004 Frequency = Quarterly Forwarded Date = 12/01/2004 and so o...

Hi, My job creates a exel and flat file. I had to stop the job in the midst. But now when I run the job again it gives the error that the files are being used by another user. And the job aborts. The files cannot be accessed or deleted either. Looks like some process of the job that was stopped is s...

thanks

char(10) and char(13) was what i was looking for.

sonia

I need to split one record from the source (flat file) to three different lines in the target (flat file). I have the length and the starting position of the source record that needs to go in as 3 different lines in the target. eg line 1 of target starts from 1 to 100 line 2 of target starts from 10...

I used something like the Routine given below to set invocation ids to job. ******************************************** Cnt = 1 Loop Start If Jobname.Cnt is running then Increment Cnt; Continue Loop; Else Exit Loop; End if End loop Run JobName.Cnt ******************************************** you co...

I generally use a FOLDER stage to check for 0KB or empty file. The two input columns for the FOLDER stage are filename and record (holding the entire data of the file or just the length mentioned).

What about using an aggregator stage to remove duplicates?