DSXchange

In DataStage on NT, how do you delete the backup hashed files (created by checking the box on the hashed stage) that are stored in DSBackup? Do you simply delete them via Windows Explorer? Or is there a cleaner way of doing it?

We will be moving from one server to another (upgrade of DataStage and hardware) and wish to preserve some of our hashed files. Not wanting to lose any data, what is the best way to copy a hashed file from one server to another? The tape option is out since neither unit has a tape drive connected to...

Hi, Suppose I have a reference lookup table (a calendar dimension table, actually) that sits in a hashed file with hashed key YYYYMM (year and month). Suppose my primary stream input has a low end and high end pair of values in this same YYYYMM format, comprising a range. How do I define a key expre...

Hi!

With DSRunJob how can i invoke multiple job instances?

Thanks!

Nuno Pimenta

Carol, I created a test job on my system (DataStage 5.2, HP-UX 11) based on your specs and data and it works just fine. My job does a simple sequential file copy of a file that has the first 5 lines of your data in it. I even tried varying some of the properties (quote character and default null str...

I am trying to get a sequential file accepted as input to my DataStage job but I keep getting an error. The file format is as follows: Column Name Key SQL Type Length Scale Nullable Display EVENTCODE Yes VarChar 8 No 10 PERSONCODE No VarChar 30 No 6 PERSONNAME No VarChar 30 No 19 OPEN No Timestamp 1...

hmm... Have you specified a key for the metadata? One more thing you can try is to separate your insert records and update records into separate sequential files and try insert only for the insert files and update only for update records. For small set of data insert or update records update option ...

Whats the tables primary key? Employee number? Read the SQL statement, you have to be identifying the primary keys (used in the WHERE clause). Otherwise, hows it supposed to find the same row? Good luck! -Ken --- BKS_Prasad wrote: > Hi every body, > I have a source as a flat file which has the > fol...

Hi every body, I have a source as a flat file which has the following records empno,ename,sal 10,"xxxx",1111 20,"yyyy",2222 40,"zzzz",3000 and target as a oracle table which already has the following records EMPNO ENAME SAL ----- ---------- ---------- 50,"eeee",2000 10,"xxxx",1111 20,"yyyy",2222 I h...

Hi all,

I would like to know how user limit in client license work. Does it count number of concurrent user on that license who connect to DS server? I run on DS5.2 Sun Solaris.

Thanks,
Boyd.

Mohan, Are you using the generated query or the user defined query? I remember finding the same problem in a job that was using the generated query and was able to get around the error by turning it into a user defined query. Hope that helps... Carrie Gotthelf -----Original Message----- From: Jaganm...

Hi all! I have an issue here. The DataStage Help documentation mentions that: DataStage supports the use of stored procedures (with or without input arguments) and the creation of a result set, but does not support output arguments or return values. A stored procedure may have a return value or outp...

Weve seen problems like this with large joins or large numbers of rows being returned, typically with Oracle lookups thrown in as well though. Still have an open ticket with Ascential. Is this a large dataset? Have you tried creating a view and then accessing the data via the view? -craig Jaganmohan...

Hi All, I am trying to pull the data from 8 tables with an OCI and a large where condition, but my job is getting aborted with the following message. Does any one out there has any clue about what I am missing here? I am using Data stage v 5.2 and Oracle 817. Appreciate your help. This is the job fl...

Hi Christian, try to move SQLBindCol function after SQLExecute function. It should work fine! Regards, Riccardo ----- Original Message ----- From: "Pelletier, Christian" To: ; Cc: "Massi" Sent: Friday, August 02, 2002 3:02 AM Subject: Whats wrong with this code...? > Okay, I am still trying to call ...