DSXchange

An xls file is not a plain text file, it cannot be used directly in a file stage for read. Save it as txt file and then use it.

In 7x you can do it two ways : get the max value from the table, and have it incremented in the transformer for each row being inserted, OR always store the max value in a text file on unix and have it exported to the job environment.

8x provides the functionality in the surrogate key stage.

Thought the same! Version 8 n bugs!

Here is the snapshot of the control file for this table. OPTIONS(DIRECT=TRUE, PARALLEL=TRUE, SKIP_INDEX_MAINTENANCE=YES) LOAD DATA length semantics byte INFILE 'ora.12285.313228.fifo.0' "FIX 1967" APPEND INTO TABLE PT_MXG_TRADE_TRNRPPL_IRS1 ( "MTM_CCY" POSITION (1:5) varchar(3), ...

Unfortunately I cannot check the control file on the oracle server installation.

Yup. The DBA provided the control file and it is truncated. Here is the error : ORA_MOPC_DB_LOAD,1: SQL*Loader-350: Syntax error at line 142. ORA_MOPC_DB_LOAD,1: Expecting valid column specification, "," or ")", found "PO". ORA_MOPC_DB_LOAD,1: "LEG2_ACCRUAL3" ...

Hi, The problem I'm facing is: I am using LOAD in Oracle Enterprise stage and the job is failing because the control file is being truncated. The same job runs fine with another schema which has relatively less columns compared to the one failing. The DBA says its something Datastage may be doing. I...

Does anyone have any idea about this particular error? I found something in Server Forum but no resolution. Error : ldFabLocation2(xfmDwid).#1.xfmDwid: |Error 11 in GCI Link initialisation After cleaning up this job and re-running : I keep getting this error : Error : xfmDwid,1: Unable to run job - ...

Let me clarify:

The source stage metadata needs to be supplied at runtime as well.

Hi, Apologise if I am repeating a previously posted query. My search has not yeilded any results. Is there anyway to provide runtime column defintion for Oracle source stage? I have over 200 tables to be loaded which read from Oracle table itself and simply do an insert to another table. Is there an...

Connection to Server has timed out. Please relogin :D

Done it!

Used the "MAkefile" script which come with the installation cd to create shared object.

The option it uses on AIX are: -G -qmkshrobj=1000

The routine is available in transformer and the job compliles as well. But at run time,This is the error i am getting : Transformer_2: Failed to load the library "V0S2_test_parallel_routine_Transformer_2.o"; either the directory containing the library file is not on the library search path...

Nope it doesnt work!

Can some one pls send me a step wise procedure to create and run a parallel routine?

Thanks.

We have Visual Age C++ installed and xlC_r is also available.

The values for the env vars are :

APT_COMPILEOPT = -O -c -qspill=32704
APT_COMPILER = /usr/vacpp/bin/xlC_r
APT_LINKER = /usr/vacpp/bin/xlC_r
APT_LINKOPT = -G

I have the .o file. Dunno wat to do after that!