Search found 7201 matches

by admin
Wed Jan 16, 2002 12:56 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: metastage
Replies: 0
Views: 411

metastage

Is there anybody that already worked with metastage?
is it possible to send me the data model?

thanks
Gisela Marques
by admin
Wed Jan 16, 2002 10:11 am
Forum: Archive of DataStage Users@Oliver.com
Topic: SQL in a routine
Replies: 9
Views: 2985

please, send everything you have, if you can.

best regards
by admin
Wed Jan 16, 2002 10:06 am
Forum: Archive of DataStage Users@Oliver.com
Topic: SQL in a routine
Replies: 9
Views: 2985

yes, thats what im looking for. Anything you have will help me a lot.

thank you very much.
by admin
Wed Jan 16, 2002 9:10 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Migrating DS4.2 from Solaris 2.7 to HP UX 11
Replies: 1
Views: 409

Migrating DS4.2 from Solaris 2.7 to HP UX 11

Hi, Ive developed my jobs/project running on a DataStage Server 4.2 on Sun Solaris 2.7, and now we are going to migrate DataStage server to a HP UX 11. What are the consideration and major impact we need to look into. We use HASH files, Oracle native connection, etc. Your advise is greatly appreciat...
by admin
Wed Jan 16, 2002 2:58 am
Forum: Archive of DataStage Users@Oliver.com
Topic: DS 5.1 - server start/stop with "dsadm"
Replies: 2
Views: 1540

DS 5.1 - server start/stop with "dsadm"

have a problem in doing start/shut down the datastage, logging in as dsadm. Have done the following steps to bring the datastage up and encountering the following error.. /ds/dsadm> cd $dshome /ds/dsadm/Ascential/DataStage/DSEngine> bin/uv -admin -stop /etc/ds.rc[33]: syntax error at line 13 : `; un...
by admin
Wed Jan 16, 2002 12:06 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Quality Manager
Replies: 0
Views: 400

Quality Manager

Hi World Somebody knows how to use DS Quality Manager?? I had initial problems with the ODBC Conection (Microsoft Oracle ODBC) but it corrected, when i start the QM, i receive a message error : "File not found. Pwbas13.dll". what happens??? I expect you can help me. Thnks Miguel
by admin
Tue Jan 15, 2002 10:12 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: SQL in a routine
Replies: 9
Views: 2985

Heck, Im interested... one mans common is another mans magic, ya know. Is this something you could post to the list? -craig "Michael Hester" To: datastage-users@oliver.com Subject: Re: SQL in a routine 01/15/02 02:59 PM Please respond to datastage-use rs Luiz, You can call a UV basic routine that op...
by admin
Tue Jan 15, 2002 10:06 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: SQL in a routine
Replies: 9
Views: 2985

Hi I have a RedBrick database on UNIX and achieve this by calling a UV Basic routine that shells out to UNIX and runs an SQL script. Please see below: -----------------------------------------------------------------------------------------------------------------------------------------------------...
by admin
Tue Jan 15, 2002 9:59 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: SQL in a routine
Replies: 9
Views: 2985

Luiz, You can call a UV basic routine that opens a connection to whatever database (ORACLE, SYBASE, ACCESS) you would like. It requires that you understand what the interface is and are comfortable with basic. This is quite common code and is extensively used in the field. I have an example of this ...
by admin
Tue Jan 15, 2002 9:52 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: SQL in a routine
Replies: 9
Views: 2985

Luiz, We have managed to pass SQL in a routine and execute it against a Sybase db on UNIX. We have just simulated a unix command line call to isql. Id imagine thered be a corresponding Oracle command line interface where you could pass and execute SQL. Let me know if this is what youre after. regard...
by admin
Tue Jan 15, 2002 5:16 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: ds_loadlibrary: error in dlopen on DataSateg 5.1 on UNIX
Replies: 6
Views: 1085

Hi Craig, Yes it was. Thanks a lot. ) P.S. On the readme.txt that was on my installation CD there wasnt any mention about this problem with Oracle Client Library. Thanks Again Giovanni Boccia Sales Engineer Direzione Industria e Servizi Datamat - Enabling Your Future ----- Original Message ----- Fro...
by admin
Tue Jan 15, 2002 4:47 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: SQL in a routine
Replies: 9
Views: 2985

Here is my problem

I want to take de Max() of one field, without using the ORAOCI Stage. I Know that with the OpenSeq/ReadSeq i can get values from a file, but the value that i want to get is in an Oracle Database.

well, thank you anyway!

[]s
by admin
Tue Jan 15, 2002 9:00 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Space Req for DS
Replies: 2
Views: 624

All log file information is written to the project directory, Ive had a situation in the past where a job processing millions of rows wrote out a warning message for almost every row due to a write error on the database. This was enough to blow the disk space and cause some job corruption problems. ...
by admin
Mon Jan 14, 2002 7:46 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: ds_loadlibrary: error in dlopen on DataSateg 5.1 on UNIX
Replies: 6
Views: 1085

Dont know anything about ODBC as we dont use it, but this is straight from the readme for the 5.1 server: Re-linking Oracle Client Library for Oracle OCI 8i and Bulk Loader Plug-ins --------------------------------------------------------------------------- On Compaq Tru64 and HP-UX platforms, in or...
by admin
Mon Jan 14, 2002 6:57 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: For anyone who has upgraded to 5.1 on Unix
Replies: 4
Views: 773

I have seen similar error messages when the client and server versions are not in sync. I have also experienced problems with the Oracle plug-in during a DS upgrade. I had some DS projects get the upgraded version and in a few projects the Oracle plug-in was not upgraded. I created a new project (wh...