DSXchange

Hi friends, Im getting this error can anyone help me how to look in unix for the detailed error DataStage Job 108 Phantom 6175 Program "DSD.RUN": Line 2157, Variable previously undefined. Zero length string used. Subroutine "DSU.GetFileDate" called with 4 arguments, 2 were expect...

Hi Friends, I have a source date column which is of YYYY-MM-DD HH24:MI:SS , I want to load in the target in the form of YYYY-MM-DD I have used below queries. But then TO_CHAR(trunc(DATE), 'YYYY-MM-DD HH24:MI:SS') for this query at my source side it is still giving YYYY-MM-DD HH24:MI:SS and for this ...

Hi Friends,


I am writing flat file to oracle using Bul Loader in DS , I want to call a procedure with date parameters after the load happens.

But the bulk loader doesnt seem to have any option to call after SQL.

Could any one please suggest me

Thanks
Karthik

Hi Friends,

Im getting 1 row from input( source) and I m having 11 hashfile lookups in the job and my ouput is only 1 row. in my server job writing to flat file from oracle.

But Im getting reconciliation error as

In rows as 11
out rows as 1

can anyone please help me.

Thanks
Karthik

Sainath.Srinivasan wrote:Craig,

I also do not have Premium but assume you are referring to placeholders for binding variables.

Karthik,

Can you provide the full error with associated ora code.

hi

I am not getting an ora code error Im only getting

Invalid SQL SELECT statement was entered

Yes, you can but it does get a little 'tricky' and you need to understand all of the rules the stage enforces. Since you (more than likely) don't have a good way to bind the columns in the stage unles ... Hi Chulett can you please help me in detail. I dont have subcription at this moment and I am u...

Hi

Can anyone help me if we can use merge statement in userdefined sql tab in datastage server jobs?

Im getting this error

Invalid SQL SELECT statement was entered

but the same MERGE statement is getting executed at database end.

Thanks
Karthik

Hi There,

I need some info regarding Datastage Server Edition certification.

Is there any exam/certification for Datastage server Edition, If yes can anyone provide me the links to take up exam in India.


And also can anyone post me the material/topics to cover for exam please

Thanks
Karthik

Hi friends,


I am trying to extract some records to flat file from database Oracle using datastage server edition.

I am getting the following error

ORA-00600: internal error code, arguments: [ktspNextL1:4], [], [], [], [], [], [], []

Can anyone help me regarding the same.

Thanks
Karthik

Hi There,

we are using Oracle Bulk Loader(Manual)for inserting data into Target, we have written a routine for the same.

But facing some problem can anyone help me.

The error Im getting is

LRM-00112: multiple values not allowed for parameter 'userid'


Thanks

Hi there, Can anyone plz help me regarding the below error My source is orace and Im having lookup table also as an oracle writing it to flat file My source is giving 131 rows as outpu and lookup table is also giving 131 rows as output and hence Inrows are becoming 262 and out rows= 131 Im getting t...

ray.wurlod wrote:It this question any different from the one in this post? ...

Yes this is totally different.

Can anyone please help me.

Hi all,

Can anyone help me in converting


Todays date minus 04/05/2008(dd/mm/yyyy)
or

sysdate minus my date (dd/mm/yyyy)

and my output would be a number

Thanks

Hi Friends

I have Timestamp in the format as 12/07/2008 04:00:15, I want to extract just the date part as 12/07/2008.

Do we have anyfunction to do in datastage server jobs.

Can anyone help

thanks.

Hi Friends,


I am having a Date as DATE 1 in the format of 2008-60-09 00:00:00 which is YYYY-MM-DD hh:mm:ss
Now I have to do

(DATE1 minus SYSTEMDATE) + 1

can anyone help me in conversion.
Thanks