DSXchange

Create a job that writes dummy data to a file and schedule this at 6 AM. Use a wait for file trigger to stope the looping job( job #1 , placed in an integer loop in a job sequencer, have a large upper limit and small step size) once the file is detected.. you can force a job to stop running by conne...

Hi Kris, Thanks for the responce. I did try that option, but resulted in the following error. [dsdev@xyz1]# /app/ascential/Ascential/DataStage/DSEngine/bin/dsjob -run -wait -param PROCESS_STATUS=Success -param $LOGFILE_DIR="/home/dsdev/datastage/temp/log/" Test_proj SeqXYZUploadProcess.11 ...

Hi, Im running the DS job sequencer through shell script with passing some parameters. When I pass a parameter which is not been defined in the DS administrator(off course defined in the sequencer parameter grid) ,it works fine. but if the same parameter is defined in the DS administrator then it fa...

Nope it isn't japanese for 'oh-yes', its merely 'Hi' spelt incorrectly. :D

Alternatively , if you are using a modify stage and if your input column ( from SQL server) is defined as timestamp; you can define the following modify stage specification( stage-Properties-Options, -> specification) : output_col:string[20] = string_from_timestamp["%mm/%dd/%yyyy %hh:%nn:%ss&qu...

Create an environment variable with name PWD in datastage -User defined variables and assign it the value ..

Value should be dot character .

On a positive note im using certain Xpaths like the below in datastage XML input stage and they work fine. /ns1:sophis-config/ns1:application-config[@deployed="true" and @name="Transaction Loader" and @id="3"]/ns1:configvalue/ns1:participantid/@value Funnily such a comp...

You should be able to get more information on search . Especially on strings like '30107', 'JOB LOCKED' 'Design time information' etc.

Looks like the executable file for your job is de-linked with design time information?
You best option is to save the job under a different name, compile it and use it.

Alternatively : create a stored procedure that clears data in your tables. Create a job that has a stored proc stage, and and output link to capture the return code and proc message to a sequential file. Call this job first in your sequencer.

Are you looking up to the database directly? I mean , do you have a refernce link connecting to database directly? If so load the database lookup data to a hashed file and use the hashed file as a source for your refernce links and see if you have the same problem.

Before i begin, im not familiar with DS 8.x. However some hints i can offer : What are the Xpath expressions that you have defined in the output of XML input stage? They should start with /BusinessEntity/Properties/Property Eg. If you want to access the value where xsi:type="CrmBooleanProperty&...

I have already made that suggestion. In our project we also have a seperate 'log file' ( in plain text) that we are generating, a brief summary of the whole sequncer run, along with short messages about all warnings and fatal errors generated in the jobs of that sequencer. The sys admins are familia...

Im having a peculiar problem. I have 2 different jobs that execute 2 different Unix executables. One of them is a perl script and the other is a ELF executable. Both are called as Before Job Subroutines via ExecSH. Whatever the perl script writes to stdout is captured in the datastage director log m...

in my machine I am running out of space

I just hope that you did not install blah.exe