Search found 7201 matches

by admin
Tue Feb 24, 2004 5:49 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Using functions
Replies: 5
Views: 29714

Using functions

Hi, When I tried using standard string functions in DS, some of them seems to work, but some don't. For eg. Alpha("hai") - works AlNum("hai") - compile error with message: Compiling: Source = 'DSU_BP/DSU.test2', Object = 'DSU_BP.O/DSU.test2' Array 'AlNum' never dimensioned. 1 Err...
by admin
Tue Feb 24, 2004 1:12 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: db2_load
Replies: 2
Views: 19673

db2_load

No. Im loading on sun solaris 9. Etl server (sun) ---> udb server (sun) -----Original Message----- From: datastage-users-bounces@oliver.com [mailto:datastage-users-bounces@oliver.com]On Behalf Of Bill Kraft Sent: Tuesday, February 24, 2004 1:10 PM To: DataStage Users Discussion List Subject: Re: db2...
by admin
Tue Feb 24, 2004 1:10 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: db2_load
Replies: 2
Views: 19673

db2_load

Are you loading to DB2 on a Windows server?


Bill Kraft
Database Administrator
Ameritas Life Insurance Corp.

(402) 467-7241


_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
by admin
Tue Feb 24, 2004 1:08 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Explore a hash file in a sequential mode
Replies: 2
Views: 19799

Explore a hash file in a sequential mode

Hi forumers. I need to read a hash file, following the key and in a sequential order. I mean, I have to read the entire hash file, and I don't know the keys, but I know the structure of the file. How can I do this ? Thanks in advance. Guillermo P. Barsky - gbarsky@osde.com.ar Gerencia de Sistemas - ...
by admin
Tue Feb 24, 2004 12:58 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: db2_load
Replies: 2
Views: 19673

db2_load

Hello all, Im trying to load db2 from a remote server using the "db2 Bulk" stage in n PX 7.0. when i try to execute it i fails for this reasons DB2_UDB_Load_42,0: Warning: DB2_UDB_Load_42: SQL6024E Table or index "BSACT" is not defined on node "0". DB2_UDB_Load_42,0: Wa...
by admin
Tue Feb 24, 2004 4:28 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Using Link Collector
Replies: 4
Views: 24190

Using Link Collector

Hi Eric, this problem is fixed in DataStage 7. Regards, Udo Eric.Roufs@stpaul.com Gesendet von: datastage-users-bounces@oliver.com 23.02.04 15:26 Bitte antworten an DataStage Users Discussion List An: DataStage Users Discussion List Kopie: Thema: RE: Using Link Collector We're still on Version 6.0 h...
by admin
Mon Feb 23, 2004 11:52 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Relative Performance for win2000/solaris 9
Replies: 2
Views: 20255

Relative Performance for win2000/solaris 9

Hi David, yes, it's been years now!!! Hope you are doing fine. Yes. We are in the early phases of moving what we have developed on win2000 across to the 12K. (Which meant we could delay that purchase for 8 months.) The job I quoted is very simple with no opportunity for anything to 'go faster' but t...
by admin
Mon Feb 23, 2004 9:43 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Export/Import thro command line
Replies: 2
Views: 19607

Export/Import thro command line

Sorry, that should be *ADN* site. Outlook keeps 'fixing' it for me. http://developernet.ascential.com/ to be precise. -craig -----Original Message----- From: datastage-users-bounces@oliver.com [mailto:datastage-users-bounces@oliver.com] On Behalf Of Craig Hulett Sent: Monday, February 23, 2004 8:39 ...
by admin
Mon Feb 23, 2004 6:59 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: [ADMIN] Test, please ignore
Replies: 0
Views: 17248

[ADMIN] Test, please ignore

Testing some "out of office" filters. Sorry for the noise. -- Regards, Clif ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678 Web: www.oliver.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ______________________________...
by admin
Mon Feb 23, 2004 2:47 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Export/Import thro command line
Replies: 2
Views: 19607

Export/Import thro command line

Look for DSCMDIMPORT.EXE and DSCMDEXPORT.EXE where your client is installed. As at version 5.2, it will only export an entire project. Maybe this has improved in later versions. -----Original Message----- From: datastage-users-bounces@oliver.com [mailto:datastage-users-bounces@oliver.com]On Behalf O...
by admin
Mon Feb 23, 2004 12:02 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Julie A Voisine/HLIFE is out of the office.
Replies: 0
Views: 17104

Julie A Voisine/HLIFE is out of the office.

I will be out of the office starting 02/23/2004 and will not return until 02/24/2004. My cell phone # 860-690-5847 Leave Message ************************************************************************* PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the exclusive use ...
by admin
Mon Feb 23, 2004 11:06 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Export/Import thro command line
Replies: 2
Views: 19607

Export/Import thro command line

Hi All, Can we export/import all the jobs from a category through command line. I mean to say instead of using a DataStage Manager, can I do this through the command prompt itself ? Thanks & Regards, Rohan A. Kembhavi _______________________________________________ datastage-users mailing list d...
by admin
Mon Feb 23, 2004 8:55 am
Forum: Archive of DataStage Users@Oliver.com
Topic: XML Writer and Output Stage
Replies: 2
Views: 19932

XML Writer and Output Stage

have a look at http://www.dsxchange.com/viewtopic.php?t=86240&highlight=xml topic: How to write XML tags which occur more than 1 time ....cmueller's response did the trick for me! -----Original Message----- From: Tony Curcio [mailto:tonycurcio@yahoo.com] Sent: 23 February 2004 14:45 To: DataStag...
by admin
Mon Feb 23, 2004 8:44 am
Forum: Archive of DataStage Users@Oliver.com
Topic: XML Writer and Output Stage
Replies: 2
Views: 19932

XML Writer and Output Stage

Hey Kiran, How are things at the Hartford? I get ODS error email messages every now and then and think about you guys. Looks like you're working on those product files for Anne's team. How's that going? Not sure why you're having that problem. I take it the data is sorted by invoice? ksurapan@hartfo...
by admin
Mon Feb 23, 2004 8:40 am
Forum: Archive of DataStage Users@Oliver.com
Topic: XML Writer and Output Stage
Replies: 2
Views: 19932

XML Writer and Output Stage

Hi there, We are using DataStage 6.0.1 and I installed xml pack 2.0 and trying to create an xml output. I am facing a problem where there are multiple products for an Invoice and I do not know how to repeat the tags for the products. The output records looks like this. 1 2004-02-20 56789.98 Y - 12 A...