DSXchange

What happens if you make the Data Element for this column "Time"?

At 04:14 PM 7/25/01 +0100, you wrote: >Hi, > >I use DataStage 4.1 and UDB V7. > >When I use a UDB plug-in to read my data, I get the following warning: > >TESTADSInitDetVehHistExtr.OSDS_DetHist: At row 2, link "Out_T_DetHist", >while processing column "EVNT_ACTVY_ACTUAL_TM" Attempt to convert Long >...

Hi, This is my first post to this users group. I work with DataStage v4.1 running on Win2000. I am just getting into deploying packages for read/only execution. Prior to this, I had simply exported jobs and routines to a .DSX file and imported them to my target server. Now I must deploy a package of...

Hi, I use DataStage 4.1 and UDB V7. When I use a UDB plug-in to read my data, I get the following warning: TESTADSInitDetVehHistExtr.OSDS_DetHist: At row 2, link "Out_T_DetHist", while processing column "EVNT_ACTVY_ACTUAL_TM" Attempt to convert Long value "86400" to Time type unsuccessful The value ...

Derick, Although we use UDB instead of Oracle, weve had a similar problem. We solved this by using the ODBC stage instead of the native UDB plug-in. Regards, An -----Original Message----- From: derick j JOSE [mailto:datastage@rediffmail.com] Sent: woensdag 25 juli 2001 10:38 To: datastage-users@oliv...

Hello everyone, We are encountering a problem detecting the error code returned from oracle . I have ellaborated the details below. If anyone has experience with this can you please help us ? Software : ---------- Oracle 8.1.6 on NT Ardent Data Stage designer 4.1 What we are doing ------------------...

Instructions for unsubscribing from the DataStage Discussion List To leave the list, send an empty email message to datastage-users-unsubscribe@oliver.com The Mail List Manager program will send you a message asking you to confirm that you want to unsubscribe. Simply Reply to that message. You will ...

Have you IMPORTED the stored procedure definition? -----Original Message----- From: derick j JOSE [mailto:datastage@rediffmail.com] Sent: Tuesday, 24 July 2001 22:16 To: datastage-users@oliver.com Subject: Invoking oracle stored procedure from DataStage Hi, I am trying to call an Oracle stored proce...

I just did some quick playing with this, using DataStage 4.1.1. I have always thought that there is a problem with the OCI stage in relation to the derivation property. Why does it have a derivation property for each column if it doesnt use it? The ODBC stage uses the derivation as the expression in...

If you have an Ardent Before/After subroutine called ExecSQL (or similar), you can use it as a before (or after) job subroutine. In the argument box put : PassiveStageName; call ProcName(Param) In the passive stage (odbc) you have to give the connection parameters (DSN and so on). I think it is also...

Rahim, do yourself a favor and either: 1) Write and perfect the sql using something like SQL-Navigator, then cut and and paste it into the user-defined SQL section of the OCI stage. 2) Write and perfect the sql using something like SQL-Navigator, then put it into an SQL script and define the OCI sta...

Is there any way in DataStage, when it generate the query attached the table alias with the column? DSGenerate Query. --------------- Selat a,a,b from a,b where a.a=b.a Actual Query need is -------------------- Select a.a,b.a,b.b from a,b where a.a=b.a Workaround ----------- In Colums tab, add alias...

you may try to call store procedure in OCI directly, choose Updated Action as "User-defined SQL", then call your store procedure. call owner.st_name(params) xiong > -----Original Message----- > From: derick j JOSE [SMTP:datastage@rediffmail.com] > Sent: Wednesday, 25 July 2001 00:16 > To: datastage-...

Hi all, How do I remove the locks held by a process if I have killed the process itself. I tried DS.TOOLS and it is not doing the job. I am running Data Stage 3.6 on AIX. Thanks in advance Nilesh _________________________________________________________ For Rs. 20,00,000 worth of Aptech scholarships...

Hi, I am trying to call an Oracle stored procedure from DataStage using the ODBC stage which apparently supports this. However, I am unable to get it working. If someone has got this to work, can you please explain the steps in detail? I am trying to call a simple Oracle procedure which has just one...