DSXchange

This is a topic for an orphaned message.

Thank you Ray for your informations and thank you Wolfgang for your example.
Wolfgang, Ill try to perform your solution.

Regards,

Alessio

I can think of two options: - Back up the table before the jobs are run, if a job fails restore the table. This is difficult to do if the table is big. - Use DataStage to move the data onto staging tables on the target database then update the fact table using database commands within a single trans...

Hi again Kasia, Correction - the to newline expansion is handled in log processing - e.g. DSLogInfo. I could not find this in the helpfiles - Ill get in touch with our tech authors. A quick glance at the logging code has not revealed any more of these codes. There are other expansions included in DS...

Dear all, apologies if this is not of interest to you, but I dont think its been mentioned here as yet, but I thought you may want to take a glance through this release we put onto the website yesterday. It gives you an insight into how DataStage will be able to perform with the new options and func...

you could take the os/390 option for DataStage (DataStage/390 edition) this will add an additional canvas to your designer for mainframe jobs. Youll get a new set of mainframe stages and youll be able to work in the same was as for server jobs. The resultant job design will produce Cobol code that c...

Hello Alexandre, we have in every table two additional fields load_number and delete_number. Every load process gets a new number from a sequence. We do not update or delete in the table. We only insert. We process this way. INSERT the row is inserted and the load_number gets the sequence number DEL...

Hi,
Can anyone help me with the error - ds_seqput: Win32 error in WriteFile - There is not enough space on the disk. I had checked the hard disc .. it had enough space. The job worked fine after I had rebooted the server.

Regards,
A.

The UNLOCK command requires Administrator privileges. On DataStage 4.x on UNIX, this means superuser (root) access. On WinNT it means a member of the Administrators group. Ray Wurlod Trainer - Asia Pacific Region IBM Informix Training Department Level 22, 60 City Road, Southbank Vic 3006 Tel: +61 3 ...

I run the LOGTO UV and then the UNLOCK command and I still get the insufficient priveleges message. Am I doing something wrong ? -----Original Message----- From: Raymond Wurlod [mailto:wurlodr@au1.ibm.com] Sent: Wednesday, 20 February 2002 3:37 PM To: datastage-users@oliver.com Subject: RE: WARNING:...

for dynamic type 30 files the command ANALYZE.FILE <filename> will return the current statistics for the file. You can at least determine what the min modulus could be set at. If you have created non Type 30 files then you can execute HASH.HELP <filename> this will actually give you recomendations f...

Select Lists are an integral part of the DataStage engine, and you definitely can use them. You need to activate a saved Select List (use GET.LIST in a before-stage subroutine). Access the file using a UV stage, and use the "normalize on" capability. You will also need to use user-defined SQL, becau...

This has been answered on the list before, so should be in the archives. Convert your input date into DataStage internal format. It is sufficient to use Iconv(YourDate, "DDMY") because Iconv() is very flexible about separators, formats and so on, but you have to be particular about day, month, year ...

Does anyone know if it is possible to copy Stages and Transforms from 1 job to another ? It is not possible. In DataStage 5.x the ability to save Containers is introduced. Ray Wurlod Trainer - Asia Pacific Region IBM Informix Training Department Level 22, 60 City Road, Southbank Vic 3006 Tel: +61 3 ...

It is possible to access hashed files from DataStage BASIC. A sufficiently small hashed file will tend to become resident in memory as a result purely of being accessed. It is NOT possible to emulate the pre-load to memory functionality, however, unless you have access to the GCI functions that hand...