DSXchange

chulett wrote:Handle what? As noted, one cannot trim a CHAR field.

Is there a work around for this.
Do we need to change the datatype of ORD_I in the Oracle to Varchar?

Your Trim() function is wasted while the data type is CHAR because DataStage will pad a char field to the appropriate length. You need the data type to be VARCHAR for the effect of the Trim() functio ... Peek_112,3: sqlcode:1403 ORD_I:5000311 REQ_SHIP_D:2008-03-01 REQ_CAN_D:2008-03-05 PRMS_D:2008-0...

Hi, I am getting below error. JobControl (@JobAuditReport): Controller problem: Unhandled abort encountered in job JobAuditReport.JobAuditReport. JobActivity1--->Job Activity2 ---->Job Activity 3--->Job Audit Report. When i am running the sequence, all the jobs are running fine but sequence is abort...

Become a premium member. It is not expensive, at less than 30c (Rs12) per day, and you will - among other things - be able to read the entirety of the five premium posters' posts. All revenue from premium memberships is devoted to defraying the hosting and bandwidth costs incurred by DSXchange so, ...

Your Trim() function is wasted while the data type is CHAR because DataStage will pad a char field to the appropriate length. You need the data type to be VARCHAR for the effect of the Trim() functio ... I am not a Premium Member.......... :oops: Can you let me know is there any way to solve this i...

ray.wurlod wrote:Trim() either in DataStage or in the extraction SQL. ...

I have used the below Function but not able to solve the issue yet.
Let me know if i am wrong.

Trim(LnkTrmPurchaseOrder.OrderNo, ' ', 'R' )

vkhandel wrote:

ray.wurlod wrote:Did you mean ORD_I = '0009000311_______________________ ' ? ...

yes.... exactly

Is there any conversion function which i can use to solve this.

ray.wurlod wrote:U (the name of one of our posters) has not participated in this thread.

The correct spelling for the second person personal pronoun in English is "you".

I apologize, if i am wrong in my writing.
Please can someone help me solve the issue.....

Looks like you are having problems with the datatypes What is the datatype of ORD_I and PRIM_LINE_I? Try running the following queries and see if it returns any rows: SELECT * FROM P_OW WHERE (ORD_I = '0009000311' AND PRIM_LINE_I = '1') SELECT * FROM P_OW WHERE (ORD_I = '0009000311.' AND PRIM_LINE_...

dsdoubt wrote:Any inputs GentleMen?

You can have a job design like:

External Source----XML Input------Sequential File/Data set.

Pass the XML File to the File Name field in External source.

Try this.

Good luck.

Hi, I have a job reading messages from MQ. i am unable to connect to Queue manager. I have given Queue Manager and Queue name Correctly. I wanted to undertsand how communication occurs between Datastage and MQ. What authorisation should i have for the datastage userid which i am using. What should b...

You get this error when the "WHERE" clause in the update statement evaluates to false. Checkout your "WHERE" clause. Try it out in SQL plus and see what you get. Do you have a condition which is always false?(like 1=2) Still having the same problem. INSERT INTO PO_W (ORD_I, PRIM...

Have you googled for the return code. I just did and got a lot of answers http://www.google.co.in/search?q=ora-01403&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a Isn't that easier than posting this whole thing :roll: Hi Googled......and tried to solve b...

Hi I have a job design: Dataset--RemoveDuplicate---Transformer---OracleTable---Peek. Dataset has 12 records. When i first ran the job, all the records got inserted to the table. when i ran the same job again, to check the update the records are going to peek. Table has upsert logic. sqlcode:1403 is ...

Hi I am reading messages from a Remote Queue. I have mentioned the Queue Manager and Queue Name correctly. I wanted to know, if i am missing any basic things here. I have no idea, what to ask other than how to resolve this issue. I tried searching the forum and google and didnt get enough info. Let ...