DSXchange

Hi all, I got below fatal error while i tried to running a datastage error. I'm able see the data through viewdata in oracle datastage. ORA-01036: illegal variable name/number. Iam performing the reference lookup on the following SQL which is UserDefined from Table and columns SELECT MAX(CUST_KEY) a...

Thanks for the information..

Hi All,

Can anyone provide some information about Truncate table then insert rows and Clear table then insert rows in oracle stage.

And kindly let me know will give better performance if the target table has more number of rows.

I appreciate your help.

ray.wurlod wrote:Server job (as marked) or parallel job (as posted) or sequence?

Sorry this is a server job

What have you tried? IConv/OConv can handle getting your Date into the same format as your Timestamp but how will you handle the 'compare'? Meaning, will you need to convert your constant date to a zero time timestamp or do you need to compare it to just the date portion of the timestamp? Hi Chulet...

Hi I have a scenario where i have to convert a string ( which is constant and in the format 31-DEC-1981) to Date and compare that value with a Field which has been defined as Timestamp data type on the source side. My design looks like Oracle---Transformer----Oracle Timestamp field from the source i...

Thanks for your reply Chulett. But the problem is my input String format is DD-MMM-YYYY format. Wondering if this format supports datastage. inString=12-JUN-2005 I did StringToDate(inString,'dd-%mmm-%yyyy'). The output Date i got was 2005-06-01. This doesnt match with what i require. Please help me

Hello

I am reading String value as varchar from File and i need to convert that string to Date.

My input String =01-MAR-2008
My output should be=01-03-2008

Is there any functions other that StringtoDate.

Thanks

hi chulett,

I have mentioned the Final delimiter=end. I havent used any field defaults.

Hi Chulett,
My source File is ; delimited File.

The output i am getting in the target seq file is
abc def ghi jkl

Hello I have a scenario where my input File is delimited by ; and i need to produce a fixed width file. I am using seqfilestage---colimport stage---transformer-seqfile My input File looks like below with each field delimited by ; abc;def;ghi,jkl now iam parsing the four Feilds via Column import stag...

Hello I have a number Field as 000000000063.00. the total length is 15. My source is File target is File. I am reading that number Field from File as Varchar. If that number Field length is less than 15 then i need to Left pad that number with zeros to make the lenght to 15. i.e if my source value i...

Hi

i tried with same what you have mentioned. The job Still Fails even if the REJCOUNT is equal to 0. am i missing some thing

Hi
Thanks for your response . Here i will be getting only 1 row. In that Row the column REJCOUNT value might be 0 or more than 0. I want to abort only if REJCOUNT value is greater than 0.

Thanks