DSXchange

I am passing the list using pipe delimited format ("|"). I am extracting the fields in a for loop using FIELD. How do I get the last field? Taking the example given in the BASIC guide: gives me "DHHH".
How do I get "KK"?

Thanks Ray. I have a couple of more queries on routines: 1. Which are better performance-wise: routines or transforms? 2. Is it possible to give a variable list of arguments to a routine? For e.g, I have to process 10 jobs using a single routine, but a different number of columns in each job. Is it ...

We have around 30 server jobs which access ODBC stages and insert or update other tables. The databases are Informix and TeraData. Now to check for insert or update we do lookups on hash files and after comparing similar fields, we decide whether it is an insert or update. The problem here is that N...

We have some jobs which were running on DS 6.0 and Informix which we are migrating to 7.0 and TerraData. All the jobs are server jobs. But we are facing issues as record counts do not match between 6.0 and 7.0 jobs. We have fixed the TD-Informix issues. Still problems persist. Is there any differenc...

dsjob command in D7.0 has an option -report which can be used to get a status report of the job. This command has solved my problem

In director, there are tabs to clear log and status files. What is the difference between the 2 files, besides the obvious. What content is stored in the status file that is different from that in the log file and how is the status file used

How can I clear the log file from Unix? This is because the size of the file has become huge and takes a lot of time to open in director. Alternatively, can I get to know the RT_LOGnn file corrsp to a job so that I can clear it from administrator.

I am calling my DS jobs through a shell script and I want to retreive some details in the DS logs, specifically start-end time, number of records, processing time of each stage, and put them in standard text files which my script uses as logs. Is this possible using dsjob or any other commands?

RT_LOGnn is almost certainly corrupted. Did it reach 2GB? Have you been purging it regularly? A very large log can give the impression of Directory hanging; it performs a full table scan to find those records that satisfy the current filter setting. It wasn't really hanging; it was waiting. And you...

There are a host of problems, I'll relate them all in steps: 1. There is a server job which reads from and writes to TeraData tables, with a lot of transformations. This job was running fine till a couple of days ago. The first problem was the job used to abort due to interrupted socket calls for no...

We are using server jobs to access TeraData, but some jobs abort frequently, but run later with no problem. PFA the error snapshot: Event Id: 137558 Time : Tue Dec 28 22:39:22 2004 Type : WARNING User : dsadm Message : GsirDmGeoCustomerLVinod..CREATE_ACCOUNT_CUSTOMER_HASH.IDENT1.STAGE_ACCOUNT_CUSTOM...

Is there any VSS (Microsoft Visual Source Safe) plugin for DataStage? If not, is it possible to develop the same. Can anyone explain the fundamentals behind plugins for DataStage, how to develop them and how to compile and "plug them in".

I am unable to view data in a teradata API stage. My job reads from a teraData table an writes to another table. I have specified valid credentials for the teraData director, username and password. Are there any other settings to be done, besides installing the TeraData driver during installation. T...

I want to know the difference between Server and Parallerl Shared Containers performance-wise and which is recommended to be used in which type of job.

I need to view the contents of a hash file on a production server to which we cannot connect using DS, but can telnet. Is there any way in which I can view the data using uv / dssh / uvsh?