DSXchange

Yes. Even after removing the -jobstatus option, job instance going under wait mode. Here goes the piece from scriptm used for invokation - cat ${APP_WRK_DIR}elm_list_of_files.txt | while read line; do FILE_NAME=`echo ${line} | cut -d'.' -f1` FILE_EXTN=`echo ${line} | cut -d'.' -f2` ### Reset Datasta...

Even though & at the end of the command line triggers the multiple jobs with different instances, but still script is waiting for completion of that particular instance.

Does -jobstatus option ?

Hi, Am trying to execute the datastage jobs from UNIX without waiting for the job completion. I just wanted to trigger the datastage job without waiting for the job status. I just need to trigger the DS Jobs and nothing else is expected. Currently command is waiting for the Job status, which is not ...

My Bad. Here goes the results am getting. 1. Len (TrimleadingTrailing(Col))<>0 is not being supported in Stage variables. only Len(col) <>0 works ===> Not getting compiled. Ciompilation error 2. Left outer Join in look up Stage returing "Empty" rather than NULL . 3. IsNull() function never...

Hi All, We are encounetring multiple issues with transformation functions and Look up stage behaviour. We tried multiple combinations and end up nothing fruitful. Please advise,the issues which I'm mentioning are faced by any of you people. 1. Len (TrimleadingTrailing(Col))<>0 is not being supported...

Thanks Shane.

But Is it possible to right some kind of unix script which I could call in External source stage or in any other DS stage and on the basis of return code , job gets aborted?Is anything like this possible (if i do not wish to create a sequence)?

Hi All, Am reading a file on Extrnal Source Stage using a command below. Am doing this because I need to remove trailer and Header Records from file before reading. Issue is - when there are no files to load, instead of ABORT, job is throwing an warning and getting completed successfully. Can anyone...

XMLInput Stage works when XSD fname included in XML file header and same XSD is placed under XML Data file location(physically lying on ETL server) . But for MQ, Messages will be in MQ server and how XML Input stage will detect the XSD? from which Location it will pull in even though it's mentioned ...

Hi All,

Have to do XSD validation for Messages subscribed from the MQ.
What are pre-requistes for this?
like -
1. Where to keep the XSD file for Validation to happen, since Messages doesn't exist on any physical Path?

Kind Regards-

Hi All, Is there any way that, information like number of records read, rejected, Job elapsed time, job start time and end time etc.. can be gathered directly from XMETA Data Repository? Does XMETA stores these in it's DS repository?. If so, what would be possible query to fired to get all these. Wh...

Message type & Message quantity should be set to 1 while wiat time is -1.

Previously I've omitted Message type, after setting this, it's working.

Am just using - "$CC_DEPRECATED_TRANS_PROP " environmental variable to override the "End of wave". If I won't set it up, same thing is happening. Setting for this should be "Wait time : -1 ", have done this already. Man, Yes, after consuming the message from MQ also, my...

Hi. I am expecting MQ Connector to keep on subscribing messages continously, without getting stopped. However even messages are not found in Queue still it should be expecting to be running(,which is not happening right now). I've below Setup - Wait time : -1 Message quantity: 1 End of wave : $CC_DE...

Williams,

Your suggestions Worked out. thanks a lot... thank you :D

Nothing Special is happening in the DataStage Job. DataStage job is just trying to subscribe the message from MQ and we are able see these sort of Uknkown Messages even when, we just make VIEW Data in MQ Connector Stage. Have spoken to upstream users who actaully Publish messages into the MQ. They q...