DSXchange

Are you talking about Postgres "dblink"?

You will get better information at the IBM Developer Works forums for Lotus Notes

The installation guide is on your CD, I don't have one available to me now so I cannot give you the document name - but there will be a README as well as PDFs.

Since the dsenv is used for all projects you will get that default assignment for APT_CONFIG_FILE for all projects. But you can (and should) make the APT_CONFIG_FILE a parameter to all of your PX jobs and specify a different default value. You may also specify a project level default in the Administ...

Gopinath wrote:If i change the Length of the column according to the matching data then its working but that should not be the case coz in production it will differ...

Not quite sure what you mean by that part; is this join column a string?

Umm, DataStage is pretty good at reading text files in jobs and using parameters for dynamic values.

Yes, I thought it might show internal hashed file errors. The quickest solution with the highest chance of 100% recovery is to do a full project export, delete the corrupted project, re-create it & load in the jobs. If you cannot do this then we can go about looking for the cause, but we've touc...

The important part is that if you issue a "Quit" from the director and the sequence doesn't stop in a reasonable amount of time (give it a minute or two). This means that the sequencer is running something which is not interruptable by the "quit" signal. I assume that when this 20-30 minute pause is...

This type of error detection and correction is just what QualityStage components does quite well.

How is Yorkshire these days? One option you have is to use a shared container. Pass in the column_name and value as parameters, then create those column names in a modify stage and you can use them from there on. The trick is in the modify stage, where you can use a parameter value as your column na...

ag_ram - please clarify your post. Better yet, write a short job to simulate this question, turn off buffering using $APT_BUFFERING_POLICY or do it explictly in all the stages and then either prove Ray correct or incorrect. This job shouldn't take more than 10 minutes work on your part. If the asser...

The terminology is a bit unclear, but I can imagine the point of the question is asking what happens when a lookup value is changed during the execution of a job - does the value from the start of the program get used or the updated value?

At the TCL prompt or from the administrator, enter:

UVFIXFILE DS_JOBS
UVFIXFILE DS_JOBOBJECTS

and please post the results.

execute "SET.TERM.TYPE LENGTH 32766" right before your select.

We haven't come up with anything better than 30x the "substr" function and then doing a column export to merge these together again in the job.