DSXchange

There is a set of functions for obtaining information from the job log. DSGetLogSummary() DSGetLogEvent() DSGetNewestLogId() Also, the number of rows processed by an active stage is returnable by DSGetStageInfo(), while the number of rows processed by a link is returned by DSGetLinkInfo(). Check the...

Yes it is. Essentially you need to break the field of N words (N >= 0) into N rows, for example using a pivot stage, before processing via the reference link. What do you want to get out? An alternative (which kinda requires a little knowledge of dynamic array processing and DataStage engine operati...

Alexandre: Im sending you a bunch of stuff. In the .dsx file is a DataStage batch job that creates hash files based on a DS Manager library path (ie. Hashfileslookupssearchtext) parameter supplied at runtime. Ive found that by maintaining an accurate metadata library in Manager makes life easier, es...

Ask your Ascential rep about MetaStage ... amongst other things its designed to collect exactly this sort of information. -----Original Message----- From: Huygelen, Luc [mailto:luc.huygelen@eds.com] Sent: 02 October 2001 16:30 To: datastage-users@oliver.com Subject: job statistics/ job audit figures...

We would like to store some audit figures per job. Like number of records processed, rejected etc. Some of these are part of the Datastage job logging. Is there a way to process this log and store the information in a relational table ? Or is there a better way(routine) to write record counters to a...

I have a list of words in a hash table which id like to lookup against an incoming field from a flat file (the field may contain zero to many occurances of a word in the hash table). Is it possible to do this within the datastage job by defining the hash table as a reference link and putting some so...

I have a job that I run which takes in a sequential file that contains a list of files and validates whether each file exists. If not, it creates the file for me. Anytime I have a new hash file, I add its name to the sequentail file and rerun the job. Here is the code: FileName = "g:EGARepository":A...

Is this regularly reproducible or intermittent? It looks like a memory
problem, but could be permissions on the server. Have you logged a call
with Ascential support?

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Hi James My experience has been to split up complex jobs into simple Jobs. Not too many transforms in one job and not too many lookups in one job. Also, reading from an ODBC/OCI source and creating a sequential file, then reading the sequential file in another job seems to significantly increase per...

Hi Dirk, As well as the information in the online help, there are a load of useful conversion charts in the UniVerse Basic guide, appendix C1. If the manual was installed on your machine, they should be under the "Online Manuals" menu. Otherwise it can be accessed directly off your installation CD u...

I guess the obvious answer (but you probably already thought of this) is to validate all jobs which use hash stages. If someone has an easier way, I would like to hear it as well. What versions are you migrating from and to? Are you upgrading or staying with the same version? The reason I ask is tha...

Hi, All!

Please advise how can I easily recreate hash files when I migrate DS project from for examle NT box to UNIX box?


Best regards,Alexandre Stoulov
------------------------------
Consultant. Business Intelligence Projects
TERN Company
mailto:alexs@tern.ru

Dear all Surely Im not the only person whos wanted/needed to tune a DataStage application for increased throughput ... any comments, experiences, suggestions would be very welcome even if they are of the "dont bother because ..." type!! Thanks James -----Original Message----- From: Ricketts, James [...

If you can see dsexport.exe among the executables with your DataStage client (you need release 4.1.x or later - cant remember the exact value of x), you can run this from, for example, the at scheduler. However, the dsexport.exe program can only export an entire project. Syntax (from help) is: dsexp...

Wed like to automate the export of a datastage project on a regular basis, as a backup for developer code ?
Is there a better way to do this other than running it manually from Manager each day ?

regards,
Peter