DSXchange

You'd have more options if you were on a 7.x version, Sequence jobs support looping constructs there. For your version, I'd look into either hand coded job control if you are comfortable with that, or perhaps a job that reads the parameter file/table and leverages the UtilityRunJob function inside ...

Hi , I wanted to pass one parameter to a DS job from file .Actually the scenario is as follows ,I need to run a DS job N times for some different values of some ids which I can store in a file or a table. Please let me know is it possible ...? If possible how can i read parameter vlues from file ..?...

Do a select and load it to a flat file, just a few records. See if the date comes up as integers (internal format). If yes then no conversion is required, pass it as it is. Thank you I have tried the same ,The date is coming in internal integer format .When i try to update the date field with this ...

I just re-read your post and saw that you are using INFORMIX. You need to use the internal date format, so just the ICONV() part to convert your date. ... When i am viewing data from input stage->view data option it is showing integer values of dates.Can i use like following ICONV(reg_link.reg_date...

OCONV(ICONV(In.DateStringColumn,'D4MDY'),'D4/DMY[2,2,4]') Note that this does not check for valid dates. Or, as a string solution, In.DateStringColumn ...[/quote] Thanks. In my case source and target are same.i am fetching some data and trying to update the same table with some logic.IN table the f...

Hi,

Hi ,
I have one issue with the date format.Please give suggestions.

I need to convert the date format coming in mm/dd/yyyy to dd/mm/yyyy to update a data fileld in an informix table where field datatype is date

Thanks,

Issuing a call to DSLogWarn() does not trigger a job failure, that's what DSLogFatal() is used for. ... OK..But i think when it finds the exit it will exit from the loop..and continue with the statements outside the loop... After exicuting that eithr it will abort or finish ?But here it showing &qu...

Hi, I have one issue as follows.In Datastage control jobs i have written a code as below inside a while loop. If count > 3 then Call Dslogwarn("Failure"); exit end if While i am running the job the count become >3 and the job is giving the Call Dslogwarn("Failure") message in dir...

HI all, hJob1 = DSAttachJob("ABC", DSJ.ERRFATAL) LastRunStatus = DSGetJobInfo(hJob1, DSJ.JOBSTATUS) If ( LastRunStatus = DSJS.RUNFAILED Or LastRunStatus = DSJS.STOPPED Or LastRunStatus = DSJS.CRASHED) Then Call DSLogInfo("ABC", "Reseting job and last Run status") ErrCod...

Hi All, I have some performance issues with Datastage job.Job is running very slow and tranfering <1 per sec,here its around 20lakhs of record For this job the source and target are same Informix Stage and that refernces only one table Tab1 ,extracting data based on the below query select Col1 From ...

ray.wurlod wrote:

Code: Select all

Left(TheTimestamp, 19) 

or

Code: Select all

Field(TheTimestamp, ".", 1, 1)

...

Hi Ray,
Thanks.

This is working fine.But i dont know why 000 is appended at the end of the time stamp ,As it is declared timestamp 19 in source and target and bith are same table.

[/b]

I am getting the following message in Datastage Director "Extra characters at the end of a datetime or interval". Incoming date format is: 2000-09-07 09:26:27.000 ,i want to convert it to 2000-09-07 09:26:27 for comparing the date field with the date field in the table. Please provide a so...

sb_akarmarkar wrote:Das,

You can also use DSExecute function.....



Thanks,
Anupam

Thanks.please provide me the code

[quote="ray.wurlod"]You would need an appropriate DEFFUN declaration. Why not use it as a prototype for your own control job in which you call DSSendMail? If it's you calling it, you can supply whatever values you like ...[/q

Thanks .Can u give the code here?

Hi Thanks for the reply.


I want to call a unix scrpt from a contril job to send a mail notification
please provide a solution.