DSXchange

Dear all, Im getting the following error on use of an aggregator stage. Warning: GLLOAD.AGGREGATE_PERIODS: Premature EOF reading stream Warning: GLLOAD.PERIODStoMONTHS.trf_to_agg: DSD.INTClose Error -2 in GCI close. Info: GLLOAD.PERIODStoMONTHS: DSD.StageRun Active stage finishing. 5262 rows read fr...

We have started a new Yahoo Club. go to http://clubs.yahoo.com/clubs/datastagedeveloper

to check it out.

Ray has a point. I just reread your message. If I understand correctly, these 100 dbase files are all different? This is really no different to reading from 100 different tables in a relational database. Perhaps you could clarify this for us. What I was referring to in my earlier message is that I r...

This is a topic for an orphaned message.

If the table definitions are different for different tables, it cant be done in a single job. You *may* be able to do it with job control, or you may like to investigate the job control API which allows you (in DS 4.1 and later) to create jobs "on the fly" - but it is complex and you need a client l...

Dear All, I have to load about 100 dBase IV file into a single fact table, how can I achieve it in a single job. This has been a problem, since extraction of dBase IV files require an ODBC stage, and the column derivation has information about the specific dBASE file. Has anyone every tried this, is...

This is a topic for an orphaned message.

Yes, I do this all the time. Out of time just now, Ill try and post a reply for you tonight. In short, you cant easily do it in one job unless you want to start writing basic code. It can be done with a couple of jobs. Later... -----Original Message----- From: Vivek Pandey. [SMTP:vive@sonata-softwar...

However, one thing worth checking is the &PH& directory. Excessive numbers of old files here can slow down the job close down time (or at least it can in 3.5, anyway). I suggest that you look in the &PH& directory at a time when there are no jobs running. If there are a lot of files there, delete th...

Theres lots of things that might happen after the last active stage finishes and before the job finishes. These include, but are not limited to: execution of after-job subroutine freeing of memory allocated for hashed files, aggregators, sort, etc. cleaning up of disk files associated with allocated...

Set Transaction Isolation Level, Begin Transaction and Commit statements apply to the UniVerse database (DataStage engine), not to the database (UDB) to which you are connected. This is why UDB is reporting that you do not hold the locks. Use SQLSetConnectOptions() to specify that you want to exert ...

Hello, There is an interesting (at least for me issue related to time DataStage is spending while finishing job. I can see in job log: 3:58:18 AM 7/9/01 Info euShipmentProcess.ProcessShipmentInfo: DSD.StatgeRun Active stage finishing. (...) 3:59:24 AM 7/9/01 Control Finished Job euShipmentProcess. 3...

Hi, I use DataStage 4.1 and UDB V7. Can anyone help me with the following problem? Im writing a DataStage job in DataStage script, but I have some problems when I run this job. (Compilation and validation are OK) The job runs fine if I dont use Commit or Transactions, but we would like to commit aft...

dsexport.exe (4.1.x and later) allows export of project. It does not have the ability to export a single job. There is no command line utility for importing DataStage components from an export file, whether DSX or XML format.

Hi any utility to export / import a job from command line ( unix or nt ) TIA thanks and regards Sudhir Mahendru GTS/APHO-ITA/CA$H/IDMS-Datawarehouse (65) 423-7449 ---------------------------------------- Message History ---------------------------------------- From: david@barham.hm on 07/07/2001 08:...