DSXchange

Because this list can become almost like spam sometimes. A board allows access from anywhere theres a web connection available. Also, the features, text search, archival of messages, allows a reader to search back through messages for an already discussed issue. Much more full featured.

-Ken

Nothing already in existence will be changed when you switch LONGNAMES ON -----Original Message----- From: Desilets, Jean-Guy [mailto:Jean-Guy.Desilets@microcell.ca] Sent: Wednesday, 11 July 2001 21:48 To: datastage-users@oliver.com Subject: RE: set LONGNAMES ON Thanks Ray, but one last questions wh...

Francesco,

I have no experience at all with DS390. Others will have to answer this. Perhaps the complex flat file stage has a capability you could use. I only suggested a workaround based on my (server only) experience.

Regards,
Ray

Hello Ray, thanks for your prompt reply. The workaround is fine, except for the milions record that Ive to transfer from IBM/390 to DS Server machine and back, but are you confirming me that DS/390 doesnt support input variable Mainframe file (recording mode isVB) ? Thanks again, Francesco Di Gregor...

Hi Sometimes, I meet this case at HP11.0 Sometimes, David Barham guess is right. but some other cases is happened at HP11.0 When You run a job, Datastage engine call process and this process folk a child process. this child process connect tho oracle and fatch the dataset. if this process is killed ...

If the file is available as a text (sequential) file with end-of-line characters, read it with a sequential file stage type in a server job, declaring the file as containing one column of type VarChar then, in a Transformer stage, use the documented metadata to decompose it. If the file does not con...

Melvin, When this happens, I suggest you go into Oracle and see if DataStage has established a connection. If it has, check what the connection is doing. Is Oracle waiting on DataStage or is Oracle busy with the query. David Barham Information Technology Consultant InformAtect Pty Ltd Brisbane, Aust...

Hi there, were developing a prototype on customer site (Banca Nazionale del Lavoro) and weve a problem during DS cobol program execution; we didnt find the right way to read data from a VB Maniframe file (everything works fine in the case of FB Mainframe file). Could somebody tell us, asap, if DataS...

Hi, There is a DataStage job that extract records from a view table in Oracle database and perform data transformation before it loads to Unidata table. The job uses the Oracle client connection to the database server and it is using the OCI8 stage to connect to the Oracle view table. This job is sc...

At the risk of asking the bleeding obvious, why?
This list performs sterling service!

LONGNAMES is a command within the UniVerse environment. Therefore it is not set in the same way as an environment variable, as your subject line is suggesting. You can set it at any UniVerse command prompt, including the one in the Administrator client. Yes, you do need to set it in each project, bu...

In release 4.x of DataStage there is much more automatic cleanup of &PH&. At these releases you should only retain one file per job, and that relating to the most successful completion. If a job aborts, there may be additional files, which (again at 4.x) are cleaned up when the job is reset.

Katherine Lapic would like to recall the message, "Datastage Upgrade to 4.2.1 on GMIDEVL2 is complete - please upgrade your client and compile jobs".

If you do a CleanupJob jobname from TCL in a project it clears the jobs status file, log file, and also the &PH& for that project. You can issue a CLEAR.FILE &PH& from TCL in a project just about at anytime you want. If you clear &PH& from NT or UNIX, you have to deal with the directory paths undern...

Thank you, Ray and David! I removed about 300 old files (out of 310) from &PH& in development and "finishing" time jumped from 58 seconds back to 5 seconds! In production I removed already about 100 old files and going to remove another 250 files created during yesterday/today run and will check "fi...