DSXchange

Hi Guys,
Good morning.
I am getting data truncation problem.In the source Oracle table column defined as a long varchar but when i used it as varchar in datastage with max length it is telling data truncated.
Please advice me how to handle long varchar data.
Thanks in advance
Reddy

Thanks alot for quick response.
Any other thoughts please.
Thanks
Narasa

Hello sir, Currently i am taking backup of my windows server where my datastage installed (all projects) every week. But in one of my project(HR) i have to take backup of 2 Categories every day. Currently i am using windows batch file that contains following code: ***********************************...

Thank you so much.I deleted all tempfiles manually,Now my jobs are running.

Hello Sir,

Good morning.

Can i delete temp files in UVTEMP directory in Windows environment manually or thru DS ADMIN.

Thanks
Reddy

Hi Guys, I created the following routine : $INCLUDE DSINCLUDE JOBCONTROL.H EQU SLASH to "\", SPACE to " " Action = action JobHandle = "" StartTimeStamp = "" EndTimeStamp = "" ReadRec = "" WriteRec = "" RowRec = "" JobDes...

Excellent Thanks a lot guys.

Sir,

Suppose if i use DSGETJOBINFO() in the jobcontrol of a jobs and i am using jobsequencer how can i get link counts for all jobs.

Thanks
Reddy

Sir, I have job with one source and one target with 3 links one for Insert and another for Update and another for Reject. How can i get counts for all input links and output links means source count,insert count,update count and reject counts along with job name,jobstaus and start and end times. Tha...

Hi Guys,

Good evening.
I need to get first and last record from input file having millions of rows.
In unix i know the command Head but here i am using Windows O/S.
Can you please give me suggestions.

Thanks in advance.
Reddy

Hi Datastage gurus, I have a question on designing of Job audit logs. I have 8 jobs running in production but now i have a requirement like this : I have to create a Oracle Audit_log table with columns source_tablename,source_count,target_tablename,target_count,run_date. I created a Audit_log table ...

ArndW wrote:Reddy - what is not working the way you would like by using the DataTypePicS9 conversion? ...

Hi Guys,

Sorry guys.Everything is working fine.I really appreciate you guys help.

Thanks a lot guys.

Reddy

Reddy Use Routine "DataTypePicS9" as Chandru said and on top of that Divide the result by 100 to get the right decimal place for your result. eg. DataTypePicS9(000000200{)/100 = 20.00 Thanks Hi Guys, Thanks a lot for a quick responses. I need to get the output with + and _ Signs like this...

Datastage Gurus, I am getting fixed width file file from one of our users,in some fields in the last positions i am seeing EBCDIC characters,but i need to convert like the below examples: a. Billing amount value = 000000200{ Ans:the billing amount is +20.00 dollars. b. Billing amount value = 0000045...

Hi Gurus, I have both source and target tables as Oracle database.I am using custom sql in the source table to load into target. I have a situation like this: for postdate field source datatype is numeric but target datatype is timestamp so in userdefined SQL i used to_date(J1.JC_COST_DATE,'YYYYMMDD...