DSXchange

Hi ,

I would like to know is there any possibility of using more than one after job subroutine in the same job?


thanks in advance

Hi craig , I tried using this routine which was in dsxchnage forums to write the log into file. the code is ErrorCode = 0 ;* set this to non-zero to stop the stage/job $INCLUDE DSINCLUDE JOBCONTROL.H DirName = InputArg Suffix = ".txt" JobName = DSGetJobInfo(DSJ.ME,DSJ.JOBNAME) JobStarted =...

Hi ,

The end date and time can be get with the function

Oconv(Date(), "D-YMD[4,2,2]") : " " : Oconv(Time(), "MTS")

Thanks

Hi Ernie, i tried with xml stages but for xml input stage we have two options either xml document or URL/FIle path. But if we check the option URL/FIle path where can we give the url path as the input doent have anything to specify the url path and so i couldnt able to work out wih that. And Do we n...

Hi craig,

Cant we use any of the Real time stages to get the data from http to file. If we are getting the data from http server, does this server should be having any specific format to load to file either with java pack or with any other.

Any help is really appreciated.

Thanks in advance

Hi , Can any one tell me how to get the data or is it not possible to get the data from http to file. Is thee any specific format that datastage is going to accept. I herd that we can get it through Java stages but other than that is there any other option available. Any help is really appreciated T...

Hi , I have a scenario where i need to download the data from http server(www.abc.com) into a flat file. Can anyone tell me what are the stages that i need to use in order to get the data into a file.As i tried using with xml stages and i couldn't able to succeed. Any help is really appreciated. Tha...

chulett wrote:Since you can't use USERSTATUS write it to a file, that or the job's log. File would be easier to retrieve.

Hi craig,

can you please explain me how do we do it with userstatus and how do we write job log into a file

Thanks in advance

There is no output as you haven't coded any in. What exactly do you want to do with this count? Perhaps USERSTATUS would work for you? ... Hi craig , I have a question like when we create a after job subroutine , can we get the output from that routine . I mean like i used after job subroutine to g...

Hi craig , I have to get three counts based on inserts , updates, rejects and if i go with aggregator , i should go with three aggregators right? so if that is the case i need three aggregators which i am not thinking to use and i used DSGETLINKINFO in the transformer stage directly without using an...

Hi craig , I have to find the row count and insert the row count in the table.And do i need to use the user status at afterjob subroutine. i mean like where do i use the user status and i created a routine and using the userstatus for another condition in the same job. So can i use the same routine ...

Hi ray, i tried to remodify the code ErrorCode = 0 ;* set this to non-zero to stop the stage/job $INCLUDE DSINCLUDE JOBCONTROL.H StageName = field(InputArg,",",1) LinkName = field(InputArg,",",2) JobHandle=DSJ.ME Insert_Count=DSGetLinkInfo(JobHandle,StageName,LinkName,DSJ.LINKROW...

Hi ,

I checked my file path and it is correct and how do i check whether the files have read permissions or not and as craig said the View Data is in disable mode.


Thanks in advance

Hi , I am trying to do inner join using merge stage and i am giving the directory paths for two files and file names at Output tab. i am having two sequential files. wen i run the job it is giving the following error Program "DSP.Open": Line 122, Exception raised in GCI subroutine: Access ...

Hi Ray , Thanks for your help by giving a reply but i was trying to find the row count without using any routines and using the DSLINKGETINFO function in one of the stages in the job. i can able to get the row count but sometimes if i get the row count as 5 it displays as 4 and sometimes it is givin...