DSXchange

No... All the job activities in the master sequence are enabled for reset if required and then run .....

Hi I have a master sequence and child sequence which is called by the master. The master sequence properties has its add checkpoints propety set. The child sequence has two job activities and the child sequence properties is set to add checkpoints and all the job activities have their job run option...

It gives me a perfect result in the Operating system level. i.e the command displays the date and time as YYYY-MM-DD HH:MM:SS

Any ':' characters in the command will not work via External source stage. I have changed my command as

stat filename.txt | grep 'Change'|cut -d'.' -f1-1| cut -d' ' -f2-3

The stage worked Fine now

Adding escape character to quote Dint solve the problem.. While trying to view the score Datastage itself sends the commands to the operating system with proper escape characters ################################################################# #### STAGE: SrcEs_DetailFileCreationDateTime ## Operato...

Hi , I am using an external source stage to capture the file creation date and time . The source program is provided as below ls -t --full-time #pDirName#/filename.txt| sed 's/[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9] [0-9][0-9]:[0-9][0-9]:[0-9][0-9]/:&:/'|cut -d':' -f2-4 The entire command is ...

I have checked for all the Nulls from the prior stages and made all the stream columns to be Non nullable and output columns as non nullable. This solved the warning.

Hi , The Lookup stage in my design has one stream, one reference and a o/p link. The stream link contains the following columns Account Number(Not Null) Balance(Nullable) Eff date(Nullable) and End date(Nullable) The reference link contains Account Number (Not Null), Payment Date(Null). Both Account...

Hi, I am writing two columns with data type as decimal(16,2) followed by a charater field into a sequential file with the properties set as Record Delimiter = DOS style and Field Delimiter as None. I have removed the rest of record level and field level properties. The code run is good but the data ...

Well said .. The solution should be tried first .... Copy stage works to throw away data from further processing with ease...I have connected the copy stage to the reject link of the lookup stage and left the copy stage with out any output links With the above design the job compiled and ran sucessf...

Hi, The count and the reconcillation stuff happens in a After job subroutine I would need records to be flowing out of the reject link so that i gets counted by the After job subroutine but rejected records should just get ignored from the rest of the processing( neither stored nor logged any where ...

Hi , I am validating a record using lookup stage and if there is a lookup failure i need to reject that record but the rejected record need not be posted to a log(Datastage logs/log files). I am wondering is there a Do nothing functionality in any of the stages in Datastage 8.1 so that i could use t...

Thanks, I could see the link to WSDL file and i have imported its definition sucessfully into the transformer.

Hi, I dont have a tab as said.. I could see my application that i have deployed by using the options Develop ---->Information Services Application ----><My Application Name> I could see the options on this window under the task pane as below New Import Deploy Export Delete Can you please let me know...

Hi, 1) I have created/enabled/deployed(SOAP over HTTP as binding) a datastage parallel job to accept web service calls. it primarily adds an integer 2 to the input recieved and passes result back to the caller. WISD Input stage -----> Transformer -----> WISD output stage 2) on the other end i have c...