DSXchange

There is a separate manual for each plug-in stage type. These are in the Packages folder on the DataStage clients CD. When I install plug-in stages I copy the manual to the DataStage Docs folder on the client, or to a shared driver, so that they remain readily accessible without having to dig out th...

There is no specific DROP table privilege. A UV table may be dropped by its creator, or a user with DBA privilege. To determine who has DBA privilege execute the following command, either through your Administrator client command window, or in a telnet session connected to DataStage environment. (Re...

I am upgrading to Data Stage 7.0 on AIX. I went to the $DSHOME/bin directory and ran uvsh. I received the message 'This directoryis not set up for DataStage. Would you like to set it up?' When I selected 'Y'. I was given 6 options for configuring the VOC: Ideal compatibility, IN2 compatibility, Pri...

vdr123 isn't the original poster.
vdr123's the one with the urgent PX requirement!

Another approach is to use user-defined SQL and specify the constant CURRENT_TIMESTAMP (assuming that's its name in DB2) in the appropriate column position in the INSERT statement.

If it's the last record that's missing, check that the last record in the file has a line terminator (end-of-line marker). Open the file with a text editor, and position to end of the file. If this is the end of the final line, add an end-of-line (that is, go into insert mode and press Enter). File ...

Hi all, I wrote a user-defined sql query in a oledb stage: select 'N' as fund_fl, max(dim_dt_id) as dim_dt_id from dim_dt where dt_1 is not null union select 'Y', max(dim_dt_id) from dim_dt where dt_2 is not null I got the error msg: OLE DB provider error: Column does not exist. How to handle the g...

Given your constraint of having to let them "send their files", I would limit them to just that. Provide an FTP utility to allow them to send their own files to the DataStage machine in France, and have DataStage check periodically for expected and unexpected arrivals of files in one or more standar...

Can I use COLUMN EXPORT STAGE to do the flattenning part(vertical pivoting) of the data??? Can we use any of the other Restructure stages available in PX 7x? Is there other way to do it without using the concatenation of fields suggested.... Please give you feedback ASAP....its URGENT!!! Rather tha...

See http://www.dsxchange.com/viewtopic.php?t=86415

I have seen this attempted once before, an intriguing approach that was short lived due to the maintenance overhead. Essentially, it was a table driven approach. The business rule for a target column was given a name (a convention for naming the business rules was adopted), and this became the key t...

... and you can use the bulk loader in PARALLEL mode for even faster loading!

It looks like one of the commonly used controls, that DataStage clients and Microsoft Office both use, is being checked for most recent version here, and that your version of Office was installed from a network drive that is not permanently available. As to exactly which component, I have no idea! T...

praj wrote:I dont think u can call a routine in a Px job transformer.

In PX 7.x there is a new stage type called a BASIC Transformer stage, from which it IS possible to call a Routine.
(I note that the OP specified 6.x.)

What happens if you DO "wait while Windows configures Microsoft Office 2000 SR-1 Professional"?