DSXchange

If you have written the routine and saved it as .c or .cpp file you can compile using following process. Pick APT_COMPILER variable and APT_COMPILEROPT variable values from administrator. For me (linux system) these are g++ and -O -fPIC -Wno-deprecated -c . Now construct the syntax in the following ...

Hi tsktsk123 I believe handling multiple files in same job will not be a good idea if you are maintaining process control metadata for processed file status. The solution will depend on the method of scheduling the jobs. 1. If you are scheduling through some scheduling tools(like control-M), Event b...

I agree with BugFree. why would one want to add overload by creating a job for such a task.

BTW, just curious, why do you actually need to do such a thing?

I agree with BugFree. why would one want to add overload by creating a job for such a task.

BTW, just curious, why do you actually need to do such a thing?

Another way of achieving it may be... SQLSTG---->TX---->Target STG 1)Read all the rows as variable string 2)Keep the previous detail(of block 3) in stage variables 3)Append Necessary detail from Block 4 to the previous detail. 4) Put constraint as Block=4 in TX. This should work only for Sequential ...

Even though you are not the premium member you got all the information needed here. Ray: Open the file before you start the loop and don't forget to close the file (which releases the lock that OpenSeq sets) after the loop and before returning But, taking a premium membersip will be a better Idea as...

I guess, correct me if I am wrong, a Basic Transformer can only be used in SMP servers.

1. No These are PX jobs designed to load data. Teradata does have a restriction of around 15 sessions at a time, but since the jobs are running through a Grid, expectation was, if requirement crosses 15 the jobs remain in queue-- does not fail. There are no Sequence job and jobs are being configured...

Hi All We have developed around 400+ jobs and trying to schedule them using CONTROL-M. Almost every next job is using at least 1 Teradata EE stage and requesting for multiple FEXPORT or FLOAD session from Teradata. Hundreds of jobs are getting triggered at the same time and failing due to non availa...

Right! I agree to Josh. Even I could not really recreate the problem. Whereas I got the following warning which may put some light in understanding why its happening. When checking operator: When binding output schema variable "leftRec": When binding output interface field "id1" ...

Hello Ravi Could you please provide some more detail about your requirement? What exactly is " using a fild based method "? Do you want to include BATCH number as a field in this file or as a part if the file name? There may be various ways of achieving it depending on your exact requireme...

Hi We have recieved the following error while we tried running jobs with Teradata API stage(TD_XYY). This is happening for all the jobs. TD_XYY,0: Fatal Error: Fatal: MTDP: EM_NETCONN(207): Error in doing a network connect. node_node1a: Player 4 terminated unexpectedly. Could you throw some light on...

Hi, In my Job i am Using IPC. When we are running the job manually it is running fine. Through the sequEnce it is sometimes aborting. The Log file shows : Item #: 60 Event ID: 59 Timestamp: 2005-10-05 10:20:46 Type: Fatal User Name: grefadm Message: job_city_new_35..IP_02.IP_04: dsintbuf_getrow() - ...

I have a process "ds cs " which is running in UNIX.
Is this part of Datastage Process. Please let me know what it is used for , if it is a datastage process.

Thanks
Rubu

HI , There is no routine/After job for running the clear.file. There is no Manual interference in the proejct. There are around 50 instances of a Job in a sequence . When the job reaches ,say, when it is running 35th Instance in the sequence the the log of the 1st Instance gets deleted. Secondly , i...