DSXchange

but if you're using CFF stage like the additional note says, it will do the unpacking for you if your copy book (input meta data for the CFF stage) is defined correctly. If you decide to do it via the routine, remember it takes up more room (more bytes) unpacked than packed (I guess I just stated th...

it will work, trust me, and read vincent's post

if what you're after is generating a surrogate key, much like @INROWNUM, but in PX... do a search for surrogate key generation (not using the surrogate key stage) and a poster of "vmcburney". Look for the post that uses a stage variable and pay close attention to the initial value setting ...

Is that some mountain range on the east coast?

In Version 7.x (and your version of 8.x it sounds like) you need to "escape" your quotes. The value of the job parm would be: "Select to_char(APPCT_DATE,\'YYYYMMDD\') from X22.TABLE_NAME" This will work at runtime. If you do a "view data", you need to remove the backsla...

See if you can see the stages in Designer in the Repository\StageTypes\Parallel\Processing.

If you can see it there, try dragging it onto a job design. If that works, you can also drag it over to a category on the Palette (where you'd usually see it)

-Craig

Ask your DBA for the trace file that has info about the deadlock. When we have the issue, we're encountering a lot of sessions competing for the same area where the primary key is managed in the database. In Oracle you can increase INITRANS for the PK from the default (2) when the table is created ....

Hey Ernie, Currently using Version Control (VC) exclusively for migration from dev -> qa -> ua -> prod, and indicate to VC to compile after promoting the code. In preparation for 8.x and no VC (sigh), we are developing a work flow using CVS for code control and moving/managing only code, no executab...

I've had the same issue lately and DBA's are stumped. INITRANS are increased on the table and the index. With commit set at 5000 and 4 nodes, always have the issue. I've set commits to 4, then to 10 and it keeps running ok. It seems to be a matter of keeping sessions on the nodes out of each other's...

Be careful using database sequences in PX jobs... sooner or later they WILL be the slowest link in your job(s), and could slow the job(s) down significantly.

Does DataStage use the tnsnames.ora file that you added the hosts to?

The tnsnames.ora file must be the proper place under $ORACLE_HOME as set in dsenv, or else declare via $TNS_ADMIN in dsenv.

-Craig

Does DataStage use the tnsnames.ora file that you added the hosts to?

The tnsnames.ora file must be the proper place under $ORACLE_HOME as set in dsenv, or else declare via $TNS_ADMIN in dsenv.

-Craig

I don't believe it's ever worked in Server version either. Still doesn't on 7.5.2

Use the TimetFromTimestamp function to convert the timestamp to a number, then run through agg to get max, then use TimestampFromTimet to convert it back to the timestamp. Need to mess with conversion using DecimalToDfloat, I think, in order avoid a warning at runtime, since the agg expects the colu...

Ray, the poster needs to delete datasets from a script.