DSXchange

I have a job that reads from a sequential file and load them in to teradata. The job hangs without any error. The only indication is that a coredump (produced by uvsh) is produced at the unix level. The only way is to stop the job and start it again. If you start it again, then the job works properl...

Its a pattern matching string. So the match will happen only if the phone number has 3 Numeric chars, 1 alpha numeric char, 3 Numeric chars, 1 alpha numeric char & 4 Numeric chars (i.e. 920-845-5403, etc.)

I have a transformer routine. the requirement is that the transformer should identify the status of the function and it should abort if necessary. That is I will set some status inside the routine and the transformer should behave depending on that status. Similar to other inbuilt functions where th...

The error was

"ITRPrepareTPUMP_event..T_ref_remas_DPEE: CLI2: NOSESSION(304): Specified session does not exist.
ITRPrepareTPUMP_event..T_ref_remas_DPEE.DSLink1: DSP.Open GCI $DSP.Open error -100."

Now after enabling NLS, it works properly.

Thanks,
Arun

I found out the actual problem. The problem is with NLS setting. NLS is mapped to "NONE".

As per the documentation, if NLS is NONE, then none of th stage will read string data.

Regards,
Arun

I tried useing a sequential file, but its not working.

Yah the hash file is empty. Even I am not able to view the data from the Teradata API stage.

Regards,
Arun

Hi, I am reading a table from taradata using Taradata API and loading the data into a hash file. When I run the job, it keeps on running without reading the table or loading the hash file. One of the columns in the table is a varchar column. If I remove the column from the select list, the job works...

I was trying to generate a build op, which gives you the sum of the values in a decimal column. I could not save that value in a float variable. float a; a=indata1.col1; It throws the following error during compilation. "Illegal types associated with operator '+': 'float' and 'const class APT_D...

If you have killed the process from UNIX, you won't get the process id. There will be only one entry named unavilable. If you want to release these kind of locks, you have to use unlock command. The syntax is UNLOCK [NODE node [USER user.number [FILE pathname [DEVICE device.number [INODE i.node.numb...

Hi,

From the documentation, I learnt that External Target Stage is mainly used to interface with databases that are not supported by DS.

But we have to specify the name of the program. I don't know what they mean by a program and what it will do?

Can any one explain this?

Arun

The problem is that when I try to use the Oracle Enterprise stage to view data on the PX side , I get the following response: Error executing View Data command: ********** >##E TOSH 000000 17:36:38(002) <main_program> Error loading "orchoracle": Could not find "orchoracle" on the...

The DataStage server uses a combination of the UNIX at and cron system commands to provide flexible job scheduling. In the same way can someone give me information about the combination of commands used for triggering a server job.

Hi: I use CFF plugin to read an ISAM file. However it does not read the data correctly once it comes across a COMP field. I have a field XXX PIC 9(6) COMP. I edit the metadata and set this. The length of the column is 6. The Storage for the above field is 4. I am not able to change this to 6 as this...

But please make sure that you are not using sequence stage. This stage will not probagate the return values of the routine activity.

Go through the post

viewtopic.php?p=101868#101868

Arun

Hi, Craig, We have already tried that option. It says that "." is a invalid character. Vincent, We also tried the option of dragging the link, but during compilation it throws out some error. Anyway we have solved the problem by having one more sequencer. The first sequencer will call the ...