DSXchange

No, there isn't. Each DB has a different method to create a database connection and to issue the DB command. The closest you can get to a universal interface is to use the ODBC stage for the SQL. There is no builtin DS routine to read/write to any database with the exception of the direct BASIC codi...

And are you running your jobs as user "dsadmin" as well? Also try to measure your /tmp use during a run; 4% sounds like you have a lot of space left but if your /tmp only has a couple of Mb allocated it will fill up quickly and DataStage does try to clean up after itself. p.s. Please edit your topic...

The conversion of one type of a hashed file to another is through the RESIZE command. It is important to ensure that the files are not in use when you do a RESIZE and the use of the "CONCURRENT" option is generally discouraged. If a file is going to be very small (such as the RT_LOGnnn or RT_STATUSn...

Perhaps it might help to give an example of your requirements to illustrate your question. I am assuming that your question is more complicated, as you have self-evaluted yourself as an expert so it is unlikely that you are asking about the base DataStage transform functionality of mapping columns b...

If you are running your jobs as user dsadm then the permissions are most likely not your problem. The most likely cause is what Ray has already mentioned - /tmp either running out of space or inodes. These temporary files are, I think, named pipes (use ls -al and see if the first character is a "p" ...

The administrator was not designed as an interface to start and stop jobs. You could execute a SH -c "dsjob -stop <project> <job>" from the administrator or the dsjob portion straight from a UNIX shell. If you are attempting to stop a job's processes from running after a failed stop attempt through ...

When creating a new file the HFC is the only automated tool that will help you calculate these values. You can use the published information on Hashed files to manually calculate a ballpark figure. There are also the TCL commands HASH.AID and HASH.AID.DETAIL if I rememberc correctly - but they take ...

Fixed width is done by using CHAR and appropriate lengths, the contents of the data fields, at least when writing, is irrelevant. Numbers are written to sequential files as display formats, but if you wish the binary values to be stored then you can use the conversion for COMP-3.

The reset is done just before a job in a sequence is run; so it only works from sequences and the setting doesn't affect a run from the Director.

Srikanth,

the correct way to answering this question would be to ask the customer how he/she wants the notification - most likely it will be be easy to make DataStage do this. The e-mail solution was menioned by the previous poster, but there are other methods as well.

Just what the message says - the program has referenced a variable before it was assigned a value. If you use an undeclared stage variable or similar in a derivation you will see this error. Check your transform variable usage - it may even show up in red in the designer.

Use a call to UNIX shell script and use rsh.

Just as with any lookup, you will need to tell us what you are using as the key for your lookup, what criteria. You can use the DataStage command line and a SELECT clause on the DS_JOBS file but the statement depends upon what you want. For instance, you could do a "SELECT DS_JOBS WHERE CATEGORY = '...

Champa, first off, you need to insert a line at the top that reads "$INCLUDE DSINCLUDE JOBCONTROL.H". I'm surprised your routine even compiled... Please use the search functionality of this forum for either DSGetLinkInfo, DSGetJobInfo, or perhaps even better JOBCONTROL.H. This will show you some com...

Champa,

it makes no difference. Try it.