DSXchange

Both sequential files

Hey guys, The input file is as below 1|711,729a,726|h711_729A_726_ppsp|H323 1|711,729a,726|s711_729A_726_ppsp|SIP 2|729ab,726,711|h729AB_726_711_ppsp|H323 2|729ab,726,711| s729AB_726_711_ppsp|SIP The output file should be as below. Codec_Descriptor_ID=1|Codec_Descriptor_Value=711 Codec_Descriptor_ID...

Guys,

I got around that problem by putting the cat command in the job after as before-job subroutine. I did check all your suggestions but I could not find any problem with my command nor was I deleting the file after.

Thx

It does not produce the all.txt at the end.

Team, I see to have problem concatenating sequential files using cat command in execute command stahe in job sequencer. I get the following error in director. seqtest..JobControl (@Execute_Command_19): Executed: cat /export/dsadm/champa/bes.txt /export/dsadm/champa/cadm1.txt /export/dsadm/champa/cad...

Hi,

How do I convert a decimal data type to varchar datatype?

Thanks.

Thanks Siva

I will try it out tomorrow

Ray,

Can you please expand on your first sentence.

Thanks.

Team, I have 13 files with 2 columns. In each file first column is id & the second is count. What I want to do is combine all 13 files group by first column & sum the count. I tried using a link collector to combine all the files into a single file & then used an aggregator to sum up. It...

Thanks Ray. Good luck with your count down.

Hi, I have a routine that gets job statistics. It includes job name, job start time, job end time, number of records uploaded to db, number of rejects, any warnings, any db errors, & job status. It uses the following arguments: Arg1: JobName Arg2: TransformerName Arg3: DBLinkName Arg4: Maximum n...

Thanks Ray for your in depth analysis & suggestions. I made changes & the file does get appended now. You have been a great help.

Thats a good idea Kumar.

Ya, I am passing all the parameters to the routine.


Thx

Here is the code: $INCLUDE DSINCLUDE JOBCONTROL.H hJob1 = DSAttachJob(Arg1,DSJ.ERRNONE) Number_of_rows = DSGetLinkInfo(hJob1,Arg2,Arg3,DSJ.LINKROWCOUNT) Ans = Number_of_rows Status = DSGetJobInfo(hJob1, DSJ.JOBSTATUS) Job_name = DSGetJobInfo(hJob1, DSJ.JOBNAME) If Status = 2 Then Job_status = "...

I an trying to call a routine that writes to a sequential file the job status many times in the designer. It writes status correctly the first time. And when it is called the second time (after executing the second job) it writes some data into the seq file. How can I invoke the same routine & g...