DSXchange

Hi guys I'll try to load a teradata table by teradata connector. If I use the immediate mode the job (parallel) works but if I use the bulk mode the job starts but without loading data (its status is idle for all time). I have, in this case, to abort it. May anybody help me to solve this problem? I ...

Hi, I recompile the source as c++ (not c) program and, as Ruy has suggested in his comment, it works now. Craig the libpath is setted correctly. Anyway I have resolved the issue. Than you very much for your help...

Regards

Umberto

Hi I'm using, for the first time, an external routine written in c Language. I compile it using xlC_r compiler: xlC_r decode.c -c The command issued generate the object file "decode.o" I have created an external routine, "decode", setting: type "external routine" object...

Hi Kumar, how did you solve this problem?

I have the same problem. I execute all the steps described in this issue. The LIBPATH environment variable points to the folder containing the object file (file.o) but the Jobs aborts again reporting in its log the same message....

Thank you very much. I'll try to search.....

Thank you very much Ruy. I have now another question. The external routines is corretly compiled. I have compiled also the Job parallel and set, before running it, the environment variable LD_PATH_LIB with the library's path containing the .o file generated. The Job abort and the message reported is...

Hi I'm trying to compile a Parallel Job calling an external Routine. This routine is writen in c and I compile it using xlc_r compiler (option -c -q64 -O). It works fine but when I try to compile the Job Datastage return this message: "Record <routine name> in DS_ROUTINES is locked by another u...

Parallle jobs generate osh script which can be viewed in the job properties window, Generated OSH tab. If the job contains a Transformer or Build stage there may also be C++ generated; this can not b ... I can't read other....Anyway I have not the Generated OSH tab in Job properties window. I only ...

Hi I usually design a Datastage PX or Server Job and I'd know what's happened when I compile my job. For example when I generate i Job Mainframe i Know that the system produces a COBOL source program to transfer to mainframe for its compilation. How DataStage works when I compile a Px or Server Job....

ArndW wrote:Umberto - you are out of luck, such a tool doesn't exist ...

Ok, I have supposed it. Is it possible via API?

Good morning

I'm looking for a method to import a table def using an external utility to run in the command line as, for example, dsojob. May I do that?

Thank you very much

Umberto

DSguru2B wrote:Here, reference thispost. Ray has a few options for you.

I just tried one of the solution suggested by Ray. I used semicolon to separate the commands but it doesn't work.

How can I do that? I would avoid the script.....

Hi just a little and stupid question. I have to execute two subsequent DOS command in the "After Job subroutine". Does anybody remember the character to use to separate the MsDos command? I remeber ";" but it doesn't work. Thank you in advance Umberto P.S. I don't know if it is i...

Hi is it possible to stop a Job from its Job control? I have a job server, release 7.1, processing a flow of data from a sequential file to an Oracle8i Table. But now I need to add a new funcionality. The Job'll start only after checking the existence of a flat file. If the file exists then the job'...