DSXchange

To handle the dynamic filename, have the filename as job parameter like filename and date, job parameter enclosed by hash symbols. Eg.

#PATH#/#DIR#/#FILENAME##DATE#.txt

while running the job the give the value for path, dir, filename, date. so that it will pick the correct file.

Hi,

As Ray suggest put a constraint in the Transformer stage, If you want 12 digit or less than 12 digit use
Len(Link1.Column3)

Hi,

I tried to compile the job, It shows the job is running.
I stopped the all service, then start all the services, Compilation is allowed, stopping and starting of all the service.
T Sankar

Hi,

Thank you Ray,
I will work on it.

thanks & regards,
T Sankar

Hi,

Once the job compiled, status shows it is compiled.
will the process running on the server.

Thanks & regards,
T Sankar

Hi,

The Version is 5.2. XE
While Installation, any specfiy step to be followed.

thanks & regards,
T Sankar

Hi,

there is an xml document. I want the document to be used a source file and extract the data and upload it to the database. for xml there is no help available. Is there a way to read the xml document, if any one done the same, send me.

thanks & regards,
T Sankar

Hi, I executed a Job which has some basic routines, but the job doesn't finished after an hours time. In the director I pressed the stop button, the message came is, the request send to the server. I stopped the DataStage services and restarted the system, It is running. the start button adn reset b...

Hi,

How create a new file using WriteSeq. or using other statement.
Is there any other approach to create a file in routine.

with regards,
T Sankar

Hi, Routine was running with out any error. ErrorCode = 0 ;* set this to non-zero to stop the stage/job lPathname="d:ds-exercisemergefilecusttrainee.txt" llPathname="d:ds-exercisemergefilecusttrainee2.txt" OpenSeq lPathname To mailfile else Call DSLogWarn(" Cannot Open "...

Hi Ray, No message is logged prior to the abort. The line ReadSeq llPathname to FileVar Else Exit - is to move the cursor to the position where it will append the new record. It is not overwriting the record, It is reading the next line ad not writing in to the output file. at time it showing the er...

Hi mnevotti,

It is Windows based system.
then you check the task scheduler ( windows 2000 ) is started.
Once the scheduler is set to started. the scheduler in Datastage will run automatically.

with regards,
T Sankar

All, A routine is reading a line from a text file and writing it in another file. I placed the routine in the before-job subroutine in job properties. the routine read the first line of the source file and inserted the line in the destination file, later it aborts. It is not reading the next lines o...

Hi,

you can do it, In Director, Monitor is there, choose save option the value will be stored, you should run another job, watch the file, from the you take the information, update the information into file.

with regards,
T Sankar



Edited by - sankar18 on 01/10/2003 08:16:26

Hi, you define parameter in the job properties, with "parammeter name", "Prompt", "Type", "Default Value", "Help" after, you assign the parameter name with "##", #parameter name#, you need the value has to pass on run time, thus the value p...