DSXchange

Hi I have the following columns in my input dataset which is sorted on ColA colA colB colC colD colE The data is such that for a single colA it can have multiple values of other columns, for eg the data can be colA colB colC colD colE 1 1 1 1 1 1 2 1 1 1 1 3 1 1 1 1 4 1 1 1 1 5 1 1 1 2 1 1 1 1 2 2 1...

Hi all, Can anyone tell me the Difference between DB2API Stage and DB2 Enterprise stage. The documentation mentions that DB2Api is a sequential stage and DB2 Enterprise stage is a Parallel stage, other than this there is no mention. I would like to know if i have to read/load from/into DB2 database ...

And here is one SecondsSinceFromTimestamp Returns the number of seconds between two timestamps in seconds. Hi I have used this in My job but this function is returning 0 always. i used a stage variable with Integer 1 to capture the result. can let me know how to get the proper difference between 2 ...

I have a ready shell script script which can be used to append timestamp to the file name. Just tell me the excat format which you want your output file to be. May be that shell script helps you out and it can be called from after job subroutine. i have the script with me which i can use but i want...

Does appending #DSJobStartTimestamp# to the outputfile not help? Hi tried appending the #DSJobStartTimestamp# with the file name but the job is aborting with following error message test_2007-08-29 05:49:57.txt is not a valid path name :( is der any other way to append the timestamp to file without...

ray.wurlod wrote:Doesn't the Search facility work in your browser?

This question has been answered on an number of occasions. ...

Hi i searched for it a lot without any luck..and finally posted this in the forum ...if u have the link for the previous post please do post it here

Any idea on how to export the env parameters defined in administrator to the other server other than typing them again one by one???


Thanks
Narendar

Hi all, I have a requirement where in i have to find out records which were inserted after last run. for this i am writing the last run timestamp say LAST_RUN_TS into a file. the time difference between each run is around 4 hrs..now the database has two fields date CRTE_D and Time CRTE_T...now i hav...

ray.wurlod wrote:There are no such things as drivers from Microsoft that run on UNIX.

Then How do i connect to ACCESS??? Any work around??

My requirement is to access MS Access DB from DataStage 7.5.1 parallel jobs. Can i use the ODBC stage to do that. Else what is the best way to do it. The data volume that I am looking at is not huge.

Thanks in Advance.
Naren

Hi All i have a requirement where in i have to get the difference between two incoming dates as an integer value.

Is there anyway we can get it done. If there is even a part solution, please do post it here. I shall be very thankful.


Thanks
Naru.

If you still want to abort the Job sequence, you can externalize the Abort functionality in a routine outside the job. Which check if the reject table is greater than 0 records for the current run, and calls the Abort signal accordingly. As mentioned to you several times in the post and in the mail...

ray.wurlod wrote:[quote="nvuradi]i have to abort the job in Afterjob sub routine .....
can this be done??....

how can i use this ???..

1. Why? All rows that have been sent to the database have been com ...[/quote]

i have to abort the job if table already has a record.......
still unable to solve it

Hi experts ...

i am running a job and taking the log into a log file in my Unix system,
but the problem i am facing is that i am getting the log for the previous run in my log file,where as i want only log for the current run.


any suggestion regarding this would be of great help

thanks
naru

ArndW wrote:You have a reject link somewhere in your job as you specified in your original post. From which stage is this link coming from? Also, look at "Linking" in the DataStage Designer Guide starting at page 4-14.

this link is coming from an Oracle insert stage.