DSXchange

Hi Rhale,

Could you please send "http://blogs.ittoolbox.com/dw/soa/archi ... jobs-19406" model/article on "amijai_12@yahoo.com"? I am unable to get it from the above URL since it is asking for ID/PWD.

Thanks in advance
-Amit Jaiswal

Hi All, In our process three jobs are designed to run sequentially by changing the Execution Mode option to 'Sequential' in all the stages. At the same time in parameters $APT_EXECUTION_MODE is selected as 'One Process'. Everything was fine in development and we never got any error there. However, i...

Hi Ray, Yes I have specified. However, since period is not visible in the file. DS is reading this data with decimal(10,2) data type as 00012345.00. I think in ab initio they have a option whether to display period or not. In ab inition decimal(10,2) means do not do not read or write period [img] Co...

Hi, We are migrating few Ab Initio graphs into Datastage jobs. We are facing some issues while reading decimal values using sequential file stage. Source and target files are ASCII plain text files. We are reading one columns as decimal(5,2). We can see actual value stored inside the source file is ...

Hi All, I am sorry issue is somewhat different here. I am reading from a sequential file in a decimal(21,2) data type column and storing into dataset with same decimal(21,2). In next job I am reading this dataset file and sending it to sequential file target through funnel a funnel stage. In dataset...

Hi, I have column-x as decimal(21) in the source and decimal(21,4) in the target. I am reading it from ASCII format sequential file and storing into ASCII sequential file. This is nullable column and inside a source actualvalue for this column is .01. However, I am assuming that since I am reading t...

Hi,

I am sorry Ray, since I am not a premium member of this forum I am not able to see your copleter response here. I am still struggling with this. Can anyone tell me how to find and replace non-ascii/control characters from the string?
Thanks in advance.

-Amit

Hi All, Following is the code being used in Ab Initio: out.pd_into_ovrdrft_cd :: string_replace(re_replace(in.pd_into_od_cd, "[\001-\037|\177-\377]", " "), char_string(0), " " ); My understanding is Within the column pd_into_od_cd, any occurrence of a value between \001...

Hi Ray, Thanks for your quick response. However, can you please elaborate it? I am not getting what you are trying to say. Do you mean I have to type the column names manually as given and select the given metadata. But for few columns, datatype is not given. Even I am not able to find \307 as field...

Hi, We are migrating the code from Ab Initio to DataStage EE 7.5.2. We have got following metadata from Abi and the file format is EBCDIC: string("\307") aml_tran_cat; string("\307") aml_tran_type; /* NUMBER*/ decimal("\307") sor_tran_type; decimal("\307") R_C...

Hi All, I am using MQ Stage plugin to read XML messages. I am able to read MQSTR format message but not MQHRF2 message. For MQHRF2 message its giving "Fatal: The WebSphere MQ plug-in is unable to process non-string formatted messages" error. Whenever, messages are added through JMS adapter...

Hi Erne,
Its working with DSUtilityRunJob routine. However, triggering the jobs in sequence. I want it should not wait to finish one job before starting another job.
Thanks,
-Amit

Hi All, I have designed a job to read messages as job names from the MQ contineously (24x7 without stop). I have used wrapper stage to execute a shell script by passing job name as parameter. I want whenever MQ Stage reads the message it should send it to the output so that Wrapper stage triggers th...

Hi All, [img]But%20after%20reading%20one%20msg%20it%20does%20not%20go%20back%20by%20it%20self%20and%20wait%20for%20the%20next%20msg.[/img] But I can always call back this job using unix script so that it can again start hunting for the next message in the queue. Please correct me if this is wrong. T...

Hi All, If we have MQ stage used as source which reads queue from MQ Server, I want the job should be kicked off based on the availability of the message in queue. I just want to send one message with end of flag. The job should trigger itself only when there is any message in the queue and it shoul...