DSXchange

they are proper strings. for example,

dsjob -run -jobstatus ${DATASTAGE_PARAM} "${DSPROJ}" "${DATASTAGE_JOB}"

becomes

dsjob -run -jobstatus -param parm1='abc' -param parm2='abc def' abcproj abc

I am having the following two consecutives in my shell script. The second command which is dsjob says: Status code = -9999 echo dsjob -run -jobstatus ${DATASTAGE_PARAM} ${DSPROJ} ${DATASTAGE_JOB} dsjob -run -jobstatus ${DATASTAGE_PARAM} "${DSPROJ}" "${DATASTAGE_JOB}" But the firs...

Hi,

I have a set of hashfiles with live data in a UNIX box. I want to move this live data to testing server. Is there any utility to do this?

Thanks
Venkatesh

Hi, I have a requirement like this: My input is a few million rows. The file sometimes contain only one day's data and some other times, it has two day's data. So, based on the date column in the input row, I want to direct it to one of my two output links. I can read the entire file before I start ...

Kenneth

I tried your way. The metadata looks fine only. It is a fixed-width file and the "Incomplete-Column" was "Error" and I changed it to "Replace". It works fine now.

Thanks

I am trying to do "View Data" from a sequential file stage and it tells me an error saying Data Source is empty. But actually the data file is having data.

Does anyone had the same problem before?

Thanks
Venkatesh

Hi, I am getting this error in my aggregator. Short description of the problem: My aggregator gets input from an Oracle OCI stage where I fetch the rows from the oracle database ordered by four different columns. In the aggregator I have specified the sort order of the input rows as the same which I...

I am using an aggregator followed by a transformer in my job. The transformer passes on many rows to the aggregator but the aggregator keeps on accumulating the rows without passing even one row out of it. The input rows to the aggregator are sorted (for eg. sorted in asc. order on col. A and in des...

I want to know the list commands that I can execute in Datastage Administrator. Where can I get it?

Thanks in advance!
Venkatesh

I want to capture all the job log entries into a text file. How can I do it from within a Server Job? Are there some builtin routines or DS functions available to accomplish this task ?

Thanks in advance
Venkatesh