DSXchange

I think that you really don't need to go to the effort of writing something in C, the DataStage equivalent of the Oracle INSTR function is called INDEX 8)

RK, DataStage has so many components that it is necessary to find out exactly where the error is occurring. If it occurs in all the client connection tools and with different users then it is almost certain that the error is in the project and not on the client side. In that case the project is corr...

The concept of "structured" data is always relevant to setting. If I look at a table with 2 columns containing a name and a date of birth I consider this to be structured; if this table is a in an Excel sheet then it is structured for Excel; if it is a digital picture of a screen shot of the same do...

Look at Ascential Software product availability for this.

If you just read the data from Oracle without lookups you are hopefully getting several thousand rows/second, right? The lookups are slowing the job down, as they are being done explicitly for each row. You can speed these up by ensuring that you perform optimal queries, use only those columns neede...

Where do you need this timestamp? DS Jobs will let you use @DATE and @TIME to get the current time into a variable for use within a job. You can use the corresponding OS functions if you shell out to perform file copy operations. "Job Properties" is a designer box, and apart from the parameters ther...

This is difficult to answer. You keep on testing for equality and check only for true or false - there is little additional debugging possible. Please tell us what the results are for A-B when both A and B are 7 or more digits. Is the result '0.00001' or '6.02E23'?

This message is often seen in corrupted projects. Did anything go wrong during the upgrade or import into this project? Which of the tools is giving you the error (Director, Designer, Manager) or does it happen with all three?

lohiya, it sounds like your data stream is from a sequential file and you are doing a reference lookup onto your hashed file. Check to make sure that the key you declared for the hashed file is correct and that the values you are using in the transform stage to get teh hashed file records are actual...

I would have expected that a comparison of two variables of type DATE or TIMESTAMP would work - have you tried it? If it doesn't function, then you need to cast the data into a numeric (julian conversion) or a string (formatted YYYYMMDD for collation) so that you can do a comparison.

It is inefficient to try to hav the job itself check to see how long it has been running, but it should be an easy matter to have the starting program or any other program use a timer and, after the specified period of time is over, call dsjob to cancel the job.

The usual approach is to put values that can (and should) change into job parameters - things like file paths, DB userids/passwords/schemas/instances.

sobral, The environment variable is always present. What you need to have as part of your LIBPATH is an entry in there pointing to the /lib directory underneath your $DSHOME directory path. Perhaps you could "env | grep LIBPATH" and see the value. It looks like it is missing or has a syntax error pr...

Are you starting the job yourself through the Director? If you look at the first entry of the run you will see what the job settings are for the number of warning - what is your value?

Clearcase cannot do version control directly for DataStage objects directly, since they are stored in tables. The only practicalbe method (and I use that term very loosely) is to use the Export and Import functionality to control versioning between projects and between your development/test/producti...