DSXchange

Hi, Im having problem starting the DS server, when I run the uv -admin - start it gives a message stating "/etc/rc2.d/S99ds.uv StartDtscreenQix: not found" When I try to do netstat to grep the unirpc it didnt return anything. And when I tried to log in through the client it says the daemon is not ru...

This is exactly what the FTP stage type is used for. This is a plug-in stage type: if you dont have it installed already, install it with the DataStage servers Package Installer (which is a script called dspackinst on a UNIX platform). -----Original Message----- From: derick j JOSE [mailto:datastage...

Hi,
I have to transfer multiple files from multiple directories from unix server to datastage server to different directories.Can do this using datastage?if yes can I know how?

Regds
Tina

They are (by default) Type 30 files, and can therefore be accessed with regular Open and Read statements. Documentation about the structure of RT_LOG... records can be obtained by listing the file dictionary (LIST DICT RT_LOGnn). However, different record types in RT_STATUSnn have different structur...

Anyway to determine how to read these records. They seem to be saved as Type 30 files. -----Original Message----- From: Kim Duke [mailto:kduke@premierhome.net] Sent: Tuesday, 29 January 2002 1:45 AM To: datastage-users@oliver.com Subject: RE: Server side timings Tjomme The start and end times are st...

dsjob -linkinfo project jobname stagename linkname This shows (among other things) how many rows were processed along the link. This does not guarantee that rows were written to a file, because factors outside of DataStage (e.g. disk full) can intervene. If you use Job Control routines, rather than ...

Hi Karthi Ive encountered similar cleanup message after compile. I just ignore the message as the jobs have been successfully compiled anyway. Cheers winston > -----Original Message----- > From: Muthusamy Karthikeyan [SMTP:muthusamy.karthikeyan@db.com] > Sent: Friday, January 25, 2002 8:30 PM > To: ...

Some corrections inline.... At 11:24 AM 1/28/02, you wrote: > 1) You must to define your conditions between parenthesis, Parenthesis are optional and can be used to force evaluation precedence. > 2) You cant break the line, all conditions in one line, True. > 3) The if has an structure and this is: ...

John, You have two options. 1) The continuation character is the underbar "_" 2) To avoid "Nested IF" try the SELECT Statement Frank -----Original Message----- From: john Billy [mailto:jbilly70@hotmail.com] Sent: Monday, January 28, 2002 10:24 AM To: datastage-users@oliver.com Subject: continuation ...

Hi! Im coding in DS Basic and I wonder what kind of continuation sign I need when my If clause is very long. I dont want to use nested If statements. for example: If fieldA = something And fieldB = somethingB And FieldC > somethingA And fieldD < somethingB And fieldG >= something Then fieldZ = field...

The only message that appears in log is "Abnormal termination of stage REF_TB detected". My job consists in two ORAOCI8. In the first ORAOCI i select some records, and in the other ORACOCI8 i insert the records. And it works only with Rows per Transaction set to 1. Nuno Pimenta > -----Original Messa...

Hello all,

Im running a shell that call dsjob.
And i want to keep in a file the information like how many records are written to a file1 and to a file2.

So, how with dsjob can i found that information?

Thanks in advance,

Nuno Pimenta

Tjomme The start and end times are stored in RT_LOG and RT_STATUS. We created log history tables for each of these along with row counts and parameter values. You can edit these records and figure out how they work. I dont think they have ever published the format of these records. Thanks Kim. -----...

Thanks Ray and Kim for your answers on how to find out who is logged in.

Much appreciated!

Scott

Hello,

Is it possible to have timings of how much time is spend in each component in a job. Id like to tune my jobs and for that i want to know which steps are the ones that consume the most time.

Regards,
Tjomme Vergauwen