Search found 7201 matches

by admin
Fri Apr 25, 2003 6:11 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job Sequence Info on DStage 5.2 on HP-UX
Replies: 5
Views: 1190

I have a VISIO macro that reads the doc_tools.mdb and builds Project/Category/JobName documents. I would like to document the Job Sequences by Project/Category/SequenceName and generate a list of sequences where each job is used. Thanks, Chris Roberts ----- Original Message ----- From: "Ray Wurlod" ...
by admin
Fri Apr 25, 2003 11:07 am
Forum: Archive of DataStage Users@Oliver.com
Topic: SAP connectors
Replies: 0
Views: 432

SAP connectors

I have read somewhere in a white paper provided on the ascential website that the SAP connector is bi-directionnal - can extract data from sap to another environment or put data in sap R/3 from flat files, rdbms, ... But in most papers read just about the extraction ability. Have you experienced the...
by admin
Thu Apr 24, 2003 11:59 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: ODBC Phantom Error
Replies: 1
Views: 1173

These are not ODBC errors. ODBC errors have a number of tokens in square brackets at the head, showing vendor, client app, driver manager, driver name, and so on. The fact that the error numbers are negative strongly suggests that they are Oracle errors, this view is reinforced by your assertion tha...
by admin
Thu Apr 24, 2003 11:48 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Jon Information on DStage 6.0.0.17 on Sun Solaris Unix
Replies: 2
Views: 850

Kim, Why not write this as a subroutine, and get at it via UniObjects (actually DSObjects) from your VB code? Just a thought. Ray ----- Original Message ----- From: Kim Duke Date: Thu, 24 Apr 2003 08:59:16 -0700 (PDT) To: datastage-users@oliver.com Subject: Re: Jon Information on DStage 6.0.0.17 on ...
by admin
Thu Apr 24, 2003 11:33 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job Sequence Info on DStage 5.2 on HP-UX
Replies: 5
Views: 1190

Design-time information is stored in DS_JOBOBJECTS, run-time configuration is stored in RT_CONFIGxx where xx is the job number. Metadata (column names, etc.) for these is not in the public domain, therefore extracting it requires a certain amount of knowledge that is not, and will not be, published ...
by admin
Thu Apr 24, 2003 11:17 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Error : ds_ipcgetnext - timeout waiting for mutex
Replies: 1
Views: 1041

This (timeout on mutex, or spin, locks) is a known problem, particularly on HP11i, particularly on fast processors. Get in touch with Ascential through your support provider (so they are also aware of the problem), who will be happy to give you the workaround. ----- Original Message ----- From: "Rah...
by admin
Thu Apr 24, 2003 3:59 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Jon Information on DStage 6.0.0.17 on Sun Solaris Unix
Replies: 2
Views: 850

Anh I have been working with the doc tool lately. I have built a browser for it which I will make available in the next week or two. We have also created some reports which are more simpified than those supplied by Ascential. It is a little tricky to get sequences into the doc tool especially if you...
by admin
Thu Apr 24, 2003 2:33 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Jon Information on DStage 6.0.0.17 on Sun Solaris Unix
Replies: 2
Views: 850

Jon Information on DStage 6.0.0.17 on Sun Solaris Unix

I am also trying to automate documentation not available in MS Access database Reporting Assistance. Is it possible that I can have a copy of your code that you sent to Chris Roberts. Besides job Sequence Information, are there other objects which have Parallel jobs and Server job definitions? My em...
by admin
Wed Apr 23, 2003 7:03 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job Sequence Info on DStage 5.2 on HP-UX
Replies: 5
Views: 1190

Sure, Id love a copy of your code. Thanks Kim. My email is croberts@alexlee.com All the best, Chris Roberts ----- Original Message ----- From: "Kim Duke" To: Sent: Wednesday, April 23, 2003 1:43 PM Subject: Re: Job Sequence Info on DStage 5.2 on HP-UX > Chris DS_JOBOBJECTS holds all the job definiti...
by admin
Wed Apr 23, 2003 6:04 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: ODBC Phantom Error
Replies: 1
Views: 1173

ODBC Phantom Error

Hello All, I get the following warning when i read data from an ODBC source and insert it to an OCI9 target. The job loads the data fine, but while finishing up it throw this error message. DataStage Job 436 Phantom 15825 DTL-00264 DBAPI Error. DB_DESCRIBE failed for file MetaStage_Loc_Info. DTL-012...
by admin
Wed Apr 23, 2003 5:49 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Which version
Replies: 1
Views: 466

6.0.1.5, which will support NLS. Lester F. Callif | Manager | BearingPoint Consulting | Denver, Colorado Mobile 303.596.8422 | Fax 707.988.0160 -----Original Message----- From: T Sproull [mailto:tsproull@yahoo.com] Sent: Wednesday, April 23, 2003 10:40 AM To: datastage-users@oliver.com Subject: Whic...
by admin
Wed Apr 23, 2003 5:43 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job Sequence Info on DStage 5.2 on HP-UX
Replies: 5
Views: 1190

Chris DS_JOBOBJECTS holds all the job definition records. Field 40 of the root record has a "2" in it if it is a sequence. The key looks like this J333ROOT Where 333 is the job number. The depend jobs is what you want. Field 31 holds the depend job names. Field 32 holds the type. Jobs are type 0. Th...
by admin
Wed Apr 23, 2003 4:39 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Which version
Replies: 1
Views: 466

Which version

Hello,

We are currently at version 4.2.1.R8 on AIX. Which is the better upgrade
path... to 5.1, 5.2, or 6.01.

Thanks.
Tom

__________________________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com
by admin
Wed Apr 23, 2003 2:46 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job Sequence Info on DStage 5.2 on HP-UX
Replies: 5
Views: 1190

Job Sequence Info on DStage 5.2 on HP-UX

I am trying to automate some documentation that is not available in the Access database of the Reporting Assistant. We are running DStage 5.2 on HP-UX. Does anyone know which files hold the Job Sequence information?

Thanks,
Chris Roberts