DSXchange

I encountered remote file access problems with dsjob run via Autosys product. Has anyone successfully run a DataStage job (dsjob.exe) through the Autosys scheduler on Windows 2000 sp2 ?

Thanks,
Yiming

I have set the auto-purge to "over 1 days" at project creation. I would like to change it to "up to previous 2 job runs". Plan to do it in the DataStage Administrator. But the documentation says that it will be applied only to new jobs created in the project. For existing jobs I have to do it indivi...

Heres a snippet that weve used to get next Monday. You should be able to modify it for your needs. WorkDate = Iconv(Arg1,D/DMY) DayNo = Oconv(WorkDate,DW) If DayNo = 1 Then Ans = WorkDate End Else Ans = WorkDate + (8-DayNo) End Ans = oconv(Ans,D/DMYWA) Regu -----Original Message----- From: BHays@pen...

"BCI" stands for "BASIC SQL Client Interface", which is the set of functions DataStage uses to connect to, send SQL statements to and retrieve results from, ODBC and UV data sources. The BCI functions mimic functions described in the ODBC API. The DataStage component you were using was DSR.MetaGeta ...

So does OCONV(@DATE, "DWA") at much reduced processing cost. @DATE is initialised to the date the job started, and remains constant throughout execution of the job. If you need the system date, use the function DATE() instead of the system variable @DATE. Another possibility, given that DataStage in...

We use the expression: OCONV(ICONV(OCONV(@DATE, D/MDY[2,2,4]), D-MDY), DWA) It gives you the system day of the week, i.e. MONDAY. Leonid BHays@penntraffic .com To: datastage-users@oliver.com cc: 10/23/2002 01:49 Subject: Input date for job sequence PM Please respond to datastage-users Hi all, I have...

Hi all, I have a job sequence that may be triggered any day of the week. No matter what day it runs, I want to get(or calculate) the date of the previous Saturday, from the system date to use as an input variable to the sequence. The previous Saturdays date (in integer form, where 0 = Dec 31, 1900) ...

Dear Ds Users, I have an Oracle OCI8 that retrieve data from the Database. I put a user defined select query within the stage. When I test the query from a sqlplus session, Igot an execution plan that use many indexes . this is rather good. When I execute the job, the query executed by DS has anothe...

Hi all I get the following error: "DSR.MetaGeta(GET.TABLES)(SQLConnect(MxRBWarehouse,system)): BCI Error:" when trying to connect from datastage 5.2r1 to redbrick 6.0.3 on another server. Datastage is on Solaris 8 and redbrick is on AIX 4.3.2. I just want to know (1) what "BCI Error" means, (2) how ...

Hi, Use the syntax - call proc_name(param1,param2,...) if parameters are required, else, call proc_name() regards, Aedla -----Original Message----- From: J. Eric Mortensen [mailto:ericm@objectware.no] Sent: Wed 10/23/2002 5:04 PM To: datastage-users@oliver.com Cc: Subject: calling Ora9i stored proce...

Hi, anybody know how to call Oracle 9i stored procedures in an After-SQL stage?

I try the following but it fails because of the first semi-colon (I think)

begin
foo;
end;

Thanks,
Eric Mortensen - ericm@objectware.no

Thanks for your responses, I tried the Ray method of using abort after 1 error and that seems to work ! Thanks, Bibhu "Simon Fryett" cc: Subject: Re: raise error 10/22/2002 01:35 AM Please respond to datastage-users Hi, you could achieve this using link variables which include the last error and SQL...

... and this is only a rule of thumb, definitely not an absolute: minimum number of Transformer stages. There are a number of conditions to vary from this, the main one being maintainability, another being to make use of the debugger easier, another to reduce complexity of a single stage. I remember...

When you import table definitions from DB2 and from Oracle into DataStage, what are the SQL data type and length (precision) of the columns that are giving you problems? In particular, is the source column really 360? Long VarChar should have no problem with a length of 360 - even VarChar is OK with...

The message is from Red Brick Warehouse. The term "source" may have confused you; it refers to "data source"; remember that the access method for Red Brick Warehouse is ODBC, so that ODBC terminology tends to be used. The problem is that a column in a the Red Brick Warehouse table STORE_DIM is decla...