DSXchange

ArndW wrote:Have you tried a reject link on the stage? ...

Impossible it is a job contro

How i can check if and how db2 answeres after a sqlexecute command?
i catch a fatal error after an update on db2 via odbc, but i have no error message, just the job aborts
Any idea about?

i cannot be to muck precisus, because was not a project of mine, just a help request. datastage 8 (works with ;) datastage 7.5.2 (works w/o ;) unix on aix type unknow db db2 on the same machine version unknow character set unknow national settings unknow I know it is no enought to have an answere, i...

not so easy in some configuration (Asia) doesn't work without

Hi all i'm facing a strange errror using odbc connection in server routine on different installation the sql instructins have problems in 'prepare step' due to semicolumns what i mean is that some enviroment accept only instruction like 'select * from dual' other only with ; at the end 'select * fro...

No here the code $INCLUDE DSINCLUDE JOBCONTROL.H $INCLUDE UNIVERSE.INCLUDE ODBC.H $INCLUDE DSINCLUDE DSJ_XFUNCS.H . . . status = SQLAllocEnv(henv) status = SQLAllocConnect(henv,hdbc) status = SQLConnect(hdbc, PDBSTGSOURCE, PDBSTGUSER, PDBSTGPSW) status = SQLAllocStmt(hdbc,hstmt) this instruction wor...

There was a misunderstanding the instruction is inside a controljob

Hi all i'm facing a strange problem i have a -1 response from a SQLPrepareinstruction that read from db2 db (that one that contains datastage metadata I'm facing the error only on unix enviroment, cannot rproduce it on Windows enviroment. The connection to the db looke work propelly (connect instruc...

i want to install IIS on a laptop with Windows XP on
is it possible?
thank's
off course i tryied to install the server 2003 version but process fails

Datastage version 7.5.2 In my Parallel job I've a Lookup between a primary source TeradataMultiLoad table of 1 million records and a secondary DataSet of 13 million records. After some minutes of elaboration the jobs goes in abort with the error listed above: Lookup,0: Could not map table file "...

Hi all i'm looking to convert some jobs using oracle oci in job using odbc oci. Do it exist any tool that do it (e.g. working on dsx)?
thank's antonio

oracle is 10g express edition

ops i answer in italian
datastage user is dsadm(it is also windows server administrator, but it is not the user i use to access to the server)
my oracle user is gisilda an hr
window server is both datastage server and client machine with windows xp home on

l'utente datastage e' dsadm, che e' anche amministratore del server (ma non e' l'utente con cui accedo a windows sul server)
se per utente oracle intendi lo schema esso e' gisilda

Hi all i'm using ds 7.5.2 on a windows server
on the same server there is an oracle client /server 10g enterprise edition (freewere)
i can connect to the db via odbc or via plug-in stage only using the anonimus user of datastage
anyone know why?
and how i can solve that problem?
Thnk's