DSXchange

I perform one more test with a file containing Unicode characters.And now the output file is also UTF-8(as specified in the Stage NLS setting). But I want to know that why the File format was ANSI,when the input file doesnot contain any Unicode characters. Is this because i have MS1252 NLS setting a...

Hello Friends, I have an ANSI File.In Datastage,I am reading that file as UTF-8(by specifying NLS option as UTF-8 in Sequential file stage properties). And at the output,I am creating a UTF-8 Encoded File(by specifying NLS option as UTF-8 in Sequential file stage properties). But the File Encoding i...

Hello friends, I have a UTF-8 Sequential File(Seq-1).I am facing ' warnings ' in reading the file. The Seq-1 File is a fixed width format file with all the columns having a specified column length.NLS Map name used for the stages which is reading the file is UTF-8. When i browse the file in datastag...

Hi Ray, I can use Wait for File Activity.But my problem is that the file name is not fixed.E.g. the Control File names can be 'GL_CONTROL_FILE_EGF.txt','GL_CONTROL_FILE_XYZ.txt','GL_CONTROL_FILE_PQR.txt' etc. And there is no fixed sequence in which the files would come.sometimes 'GL_CONTROL_FILE_EGF...

Hello friends, My requirement is that i have to keep looking for a control file(with special name) in a directory.And when the control file arrives,I have to take out a substring from the name of the control file. Below is the code of the routine: $INCLUDE DSINCLUDE JOBCONTROL.H ParamFile = Paramete...

Thanks !!!

Ok..Fine..

Can we increase the number of jobs that can be run simultaneously.
We had changed in the uvconfig file,the value of three parameters (1) GLTABSZ (2) RLTABSZ (3) MAXRLOCK

But do not much help.
Please suggest.

Hello Everyone, I am trying to run one Job Sequence which calls many 10 Instances of a Job.But at the same time,another job sequences is running which is running around 30 instances of 3 Jobs(10 each). As soon as i run my Job Sequences,it aborts and the error message is : GL_Journal_Line.NJ1_03.JobC...

Hello Friends, I have a routine which will run a Job and will keep running if a sequential file doesnot have any contents. The code of the Routine is : **************************** $INCLUDE DSINCLUDE JOBCONTROL.H ParamFile = ParameterFileName FileLine = ' ' GetSourceJob = 'FolderStagetoSF' hGetSourc...

I have to send the error message of Datastage Job to TIVOLI,so that the Production people can see the message on their console.

Actually i want to send the Iformation to IBM Monitoring tool TIVOLI. My Master sequence has job and job sequences.So now the requirement is to send the Error/Aborted Message to TIVOLI if the Job/Job Sequence in the Master Sequence Aborts. In case of Job,It is very easy ..get the NewestLogid(of Fata...

Hello friends, I want to get the status of a job (say JOB3 and JOB4) which is in a Job Sequence(say JOBSequence2).And this Job Sequence(JOBSequence2) is triggered by another Master Sequence(say JOBSequence1). JOBSequence1 -> JOBSequence2 -> JOB3,JOB4 I want to get the name of the failed Job in JOBSe...

Hello friends, I have a routine which keeps running a job until the job gets some input.The input are the files in a Directory. Here i want to send a message to Tivoli if the routines keeps running the job for more than 30 minutes. Can anyone please tell which function in datastage can calculate thi...

Actually, My Requirement is to to Fetch a Column Value 'Z' from Tabel TBL used as a reference on the Input Data. TBL Structure : Field Name- X Key Y Key Z Range_From Range_To I want the value for Z where the incoming Value of some Column (say A) lies in between the Range_From and Range_To Fields of ...

Hi Friends,
How to implement a Dynamic Query in the jobs.
My requiement is to find a Column Value(say X) in Table (say TBL) where the the Value of Column(say Y) is in between Two other column values(say Range_From,Range_To)

Thanks in Advance!!!