DSXchange

Can you please help us how can we read MQRFH2 message body without header using MQ connector stage.

I am still struggling with HRF2 header.

I am not able to understand what value should I put inside header column.

Hi Guys,

Checking if anyone can help me.

Message is not generated with rfh2 header.

Hii, I have a xml and I am trying to write to mq as mqrfh2 header format message, but its not writing properly :cry: I have defined below properties in mq connector stage: 1. Defined format type as MQHRF2 2.defined an extra column name format , varbinary and selected data element as WSMQ.FORMATHEADE...

Hi, Yes i have tested with non exisence job,it goes to last part of case statement and it displays genric message in that case statement and exit from script with return code 100. sh test_script1.sh QA ValidTest #######Pre validation to check previous status of job run###############################...

Hi, I have written below code to check the pre status of job and rerun job. JOBSTATUS=`${EngineDir}/bin/dsjob -authfile /home/dsadm/pras/AuthFile.txt -jobinfo ${ProjName} ${JobName} 2>/dev/null|grep "Job Status"|cut -d':' -f2|cut -d'(' -f2|cut -d')' -f1` echo echo "#######Pre validati...

Hi,
How can we know from command line if job exists or not?
if job is not compiled, -jobinfo gives me error like cant open job, so how can I handle these two scenarios before running.

Hi,

This is what i exactly suggested,but my client is rigid,want to check the capebility of datastage

Hi,

Is there any way in datastage i can split the input file (eg 1 GB) based on size lets say 1 MB and create the multiple files.

Hi all, I have requirement where I need to trigger my job from enterprise scheduler. I am planning to design a wrapper shell scrip which is going to do below:- 1. Check the status of job (aborted, crashed, not compilter) 2.if 1 is true recompile and trigger a sequence 3. If 1 false trigger a job wit...

Hi,
I have not defined anything in record delimiterr and my source file is only having new line.
When file is created on after processing I checked the length of file in unix using command.

Awk '{print length ($0)}' output file name

And its giving 17 but source file is 15

Hi, I have a job with source as sequential file (file format is fixed width) and after transformation i need to add one more column to this file at the end but file format need to be same as it is in source,but it seems datastage is adding some sapce somewhere in file.So i am trying to do below test...

Hi, Thanks for your help. Now i am getting below error:- dsadm@ait-etl01dev:/home/dsadm/pras $ /usr/vacpp/bin/xlC_r -O -q64 -c -I/opt/IBM/InformationServer/Server/PXEngine/include myhelloworld.c -o myhelloworld_temp.o "/opt/IBM/InformationServer/Server/PXEngine/include/apt_util/ints.h", li...

Hi,

The easiest way is to write a C++ external function and call in transformer.Input of the function will be file name and data.