Search found 7201 matches

by admin
Mon Dec 10, 2001 10:03 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Help with job that aborted strangely
Replies: 1
Views: 385

Help with job that aborted strangely

Im hoping someone may have seen this behaviour and can enlighten me as to the cause... I basically had a job, one of a series called by a chunk of Job Control, that aborted. Normally the batch would have taken that in stride, stopping processing and alerting me. The odd thing was the nature of the a...
by admin
Mon Dec 10, 2001 6:12 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Client app performance issue with 5.1
Replies: 5
Views: 487

Im testing 5.1 and i have the same problem. And, if we have severals users working with DataStage 5.1, Directors behavior is strange. We tell to run a compiled job and it doesnt run. Does anybody have experience with it? Nuno Pimenta > -----Original Message----- > From: chris.thornton@ascentialsoftw...
by admin
Mon Dec 10, 2001 6:11 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Client app performance issue with 5.1
Replies: 5
Views: 487

Not quite the same (but almost certainly related!): I and several colleagues feel that client-application performance generally is slower with 5.1 ... of particular issue is the performance of the transform properties dialog, especially for editting derivations. James -----Original Message----- From...
by admin
Mon Dec 10, 2001 2:45 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Archives??
Replies: 1
Views: 345

Archives??

Where can i find the archives? At 05:27 25/10/2001, you wrote: >On 11 Aug 2000 I posted code to do this task on this list. It should >be in the archives. If you cant find it there, I can email it to you >off line. The technique is also taught on "Programming with >DataStage BASIC". Enrol, or join a ...
by admin
Mon Dec 10, 2001 10:24 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Getting the Job Nos in a file?
Replies: 1
Views: 350

Getting the Job Nos in a file?

Dear users... Im trying to get only the job numbers of all jobs in a project to output into a file? I want to clear the status files of all jobs but need only the job numbers? Can any one help? Thanx. --- Frik Lubbe --- *********************************** Sybase SA (Pty)Ltd Phone (Work) : +271120210...
by admin
Mon Dec 10, 2001 8:09 am
Forum: Archive of DataStage Users@Oliver.com
Topic: login via telnet
Replies: 0
Views: 532

login via telnet

Hi We installed Datastage as user administrator on the box. We then created a user dstage and tried to login via telnet. We got the following error Welcome to the Ardent UniVerse Telnet Server. Enter user name: dstage Enter password:******** Unable to attach to the given directory. Ardent UniVerse t...
by admin
Sun Dec 09, 2001 10:30 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: DataStage V5.1 Version Control
Replies: 0
Views: 421

DataStage V5.1 Version Control

With the new version control in DS 5.1, is it possible to label objects for promotion to a project, rather than just taking the latest revision ? NOTICE This e-mail and any attachments are confidential and may contain copyright material of Macquarie Bank or third parties. If you are not the intended...
by admin
Fri Dec 07, 2001 4:07 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Useful / Uselss date information.
Replies: 0
Views: 656

Useful / Uselss date information.

Ladies and Gents I recently discovered this little gem on the iconv routine courtesy of Peter C. I realize to some of you this will just be teaching you to suck eggs (british), flogging a dead horse(American) etc... But for everyone else it should be a useful piece of trivia again proving just how f...
by admin
Fri Dec 07, 2001 9:49 am
Forum: Archive of DataStage Users@Oliver.com
Topic: ODBC stage
Replies: 1
Views: 613

I have come across the fractional truncation before. I am not 100% certain but I think it occurs when you attempt to insert a floating point number into an integer column. The error is definitely being returned by the SQL Server database. Check the data thats going in and that the column datatypes s...
by admin
Fri Dec 07, 2001 8:36 am
Forum: Archive of DataStage Users@Oliver.com
Topic: ODBC stage
Replies: 1
Views: 613

ODBC stage

Dear all, My objective is to directly transfer the extracted data into created table in SQL 2000 using ODBC. Below is the error message appear while i try to run the validated job. Error Message: sqlTest.CTransformerStage9.DSLink19: DSD.BCIPut call to SQLExecute returned informational message. SQLST...
by admin
Thu Dec 06, 2001 3:23 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Synchronization error
Replies: 0
Views: 536

Synchronization error

Hi all,

Im running a job and in the log i see the following warning:

P1..T_PPP: Synchronization error Resource = P1.P_NEW.Out, CurWave = 14, LastWave = 14, Expected 0

Has anyone encountered this problem before?
Thanks in advance.


Nuno Pimenta
by admin
Thu Dec 06, 2001 2:37 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: DataStage jobs stopped running and client inaccessible
Replies: 3
Views: 4474

William, A couple of things: a) One of the things that concerns me the most is that you are getting numerous cases of failures caused by the inability to access your cataloged subroutines. Check the directory $uvhome/catdir to ensure it exists and what the permissions are. For example, check the fil...
by admin
Thu Dec 06, 2001 2:10 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: DataStage jobs stopped running and client inaccessible
Replies: 3
Views: 4474

DataStage jobs stopped running and client inaccessible

Hi, Our DataStage production jobs (on a HP-UX box) suddenly stopped running since 11.30am this morning. Before that everything was running fine. The DataStage jobs are scheduled to run at every 15-minute interval from 8.00am to 7.50pm. When we try to log in to the DataStage server through any of the...
by admin
Thu Dec 06, 2001 1:21 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: SQLBLK
Replies: 3
Views: 606

Provided that DataStage has been configured to talk to the Unidata server, then it should be possible to read directly from Unidata, using the Unidata stage, and write to SQL Server 2000, using ODBC, in the same job. >From: "Peggy Lee Pei Kee (COS-HO-IT)" >Reply-To: >To: datastage-users@oliver.com >...
by admin
Thu Dec 06, 2001 1:34 am
Forum: Archive of DataStage Users@Oliver.com
Topic: SQLBLK
Replies: 3
Views: 606

is it possible that we use unidata as data source and load the data directly into the table in SQL 2000? pls advise thanks peggy DataStage Developer wrote: > If you are using ODBC to load the table then there shouldnt be a > problem as long as you have the correct ODBC drivers installed. > > I dont ...