DSXchange

I find spurious and irrelevant postings to be annoying. Each one should serve a specific detailed purpose that illuminates and advances the cause of Websphere!

or not.

1000 points! Wahoo! I'll take the dsxchange T-shirt; blue, size medium...

USERSTATUS is NOT available to a EE job. Remember that @INROWNUM and @OUTROWNUM will be identical per node. Check out @PARTITIONNUM to alleviate this problem. YES - The Surrogate key generator will generate the same keys for each run. How can it not since there is no communication of the surrogate k...

I would ask why the limited records are being written to the log. Could it be there is a Constraint on the link of Otherwise? Perhaps a Peek stage is capturing the rejected records in the Director logs? If it isn't needed, remove it and let the rejected records fall on the floor. Better yet write th...

I get the impression Mr. Bland is referring to a Server job. Seems like overkill to get the filename in a EE job. Why not add the property File Name Column in the Sequential stage?

Export the entire PROD Project to a single dsx, open the dsx in some editor and do a global search and replace of MyProdDb with MytestDb, save and exit. Import the project to test and done. It's a hack and points to very poor design of your environment(s) but it will work. One primary use of paramet...

I'm guessing this would work although I cannot say if it is a reasonable solution as I have never done it;

IF ALPHA(CONVERT(CONVERT(STRIPWHITESPACE(<link.colname>),"-","A"),"'","A")) THEN @TRUE ELSE @FALSE

Seems obvious which leads me to believe I am missing the point. Can you do a save of the input tab of the modify stage into a table definition and then do a load into the output tab of the same table definition? It appears your problem is that there is no easy way to drag and drop the link columns f...

I'm new to Teradata and used to DB2. Is there a way to read/write to Teradata, in parallel, the same way one can in DB2. That is, in DB2 one can partition a table and then read/write by nodenumber into a given set of partitions in a DS job without re-partitioning. Likewise the data can be sorted and...

Seems pretty straightforward, therefore I'm not sure I understand the problem. If all the good records are committed when the commit level is 1 and some good records are being dropped when the commit level is set to a number higher than 1 then isn't it obvious that when a rollback occurs when a bad ...

Not sure if this is runtime enough for you but; 1. Save a Table definition from the columns tab 2. Edit the Table definition to suit 3. Goto the Parallel tab and right click to save as a *.osh schema file. 4. Put these where the job can access them. In my case it was ftp'ing them to UNIX. 5. Run the...

You've corrupted or otherwise lost the index to the jobs. I assume you can't see them in Designer under the jobs category? Can you go to File on the main menu in Designer and open a job from the list? If so, then make sure no one is logged onto the DataStage server (No active ports except dsrpc LIST...

My two cents is that the only way to get the CurrentTimeStamp, for a given row being processed, is via the Transformer stage. It can't be done with the Modify stage or any other standard (non-custom, generic) EE stage. I'm throwing this bold assertion out there in the hopes of it being disproved.

Coffee mug... definitely. Some call me a real tool so that probably counts as well although I do not market myself as such.

I've used a Pager, a Telephone, a laptop AND a PC in the course of working with DataStage. Sometimes I write stuff down so I guess pen and paper are also useful tools. A whiteboard can come in handy but is a pain to carry around.

Easily verifed. Log onto the ETL Server using the userid that will be running the job do;
rsh dbsp8003 date
If the command is processed correctly the problem lies elsewhere. If not then either it is rsh or the userid.