DSXchange

Hi If You Know Job No (Internally, DataStage job has unique job no) First Check Process with Job no. You can see datastage directory menu ( Job --> Cleanup Resource) If this menus disable (check admin menu in ds administrator) And Second Check Lock or Process and release all Lock or Process related ...

Thats happened with me as well. What we do is stop and start the server again (UNIX). Im not sure of the commands for 2000, but the manuals should have it. Regards Denzil -----Original Message----- From: YN [mailto:yn_ds@yahoo.com] Sent: Monday, February 18, 2002 12:13 PM To: datastage-users@oliver....

Hi All, I was editing a job and suddenly the connection got broken. Now I am not able to access the job in designer - it gives the message "Job XXX is being accessed by another user." How do I reset this status. For info, I am am running DS 4.2 on Win 2000. Thanks in advance. Regards, YN ___________...

Hi there, Im running in a problem. Im trying to write record to hash file and some of them are generating a Warning and are not considerated. the Warning is ..: ds_uvput() - Write failed for record id record value At the end of the job Ive phantom warning that for each record not cosiderated cause w...

Thanks -----Original Message----- From: Raymond Wurlod [mailto:wurlodr@au1.ibm.com] Sent: Monday, February 18, 2002 4:02 PM To: datastage-users@oliver.com Subject: Re: Email notification? The easiest way to do this on your platform and at your release is to download one of the third party command li...

DOS also has commands you can make use of which test for the existance of the file. if it does not exist set flag and abort the process. -----Original Message----- From: Simon Vollett To: datastage-users@oliver.com Sent: 2/18/02 12:19 AM Subject: RE: Email notification? Thanks -----Original Message-...

Hello all, Im using datastage 4.1 on Windows 2000. I have a job that reads in a text file from the working directory. The file is austomatically deleted after the job is run. Every day, a new file is supposed to be placed in the working directory and the job run again. Im wondering if there is a way...

The easiest way to do this on your platform and at your release is to download one of the third party command line mail programs on the net (such as blat), and invoke this from, perhaps, a before-job subroutine or a job control routine via DSExecute(), with a shell argument of "NT". Chase back throu...

In the new Designer, I like the fact that the Stage palette is dockable and everything, but something seems to be missing. In the past, if I configured the palette to remove the stages I either never used or hardly ever used, I could always still add them to my jobs by going back to the old-fashione...

Ok, how about a different 5.1 FTP problem? Ive just upgraded my production system to 5.1 and, in spite of not having a problem in my test environment, Im getting weird ftp failures in one particular job. Of course, manually ftping the file works fine, and the one that fails is in a job that does thr...

Hi DaeHwan, Im not sure what you want to do with the metadata information. Do you want to save it to a file? If so, how do you want it to look (comma-separated, normalised vis-a-vis single and multi-values..)? Are you a MetaStage user and, if so, do you want it to detect what you are doing? What is ...

Mr Kims BASIC program sought to generate a list of all values from fields 12, 15 and 16 of the DS_METADATA table. Because these contain multi-valued data, he chose an awkward methodology which, among other things, invoved processing the entire table three times (three SELECT statements) when one sho...

This is a topic for an orphaned message.

DaeHwan, Probably your best idea (least change to your code) is to promote the values in the Select List into fields by applying the RAISE() function. For example: SELECT EVAL RAISE(@RECORD) TO SLIST 0 FROM DS_METADATA;" Hope this helps. -----Original Message----- From: DaeHwan Kim [mailto:whatcanid...

Hi Ray But Dynmic array is empty, maybe I made a mistake when Select value, When some field has multi value. ReadNext, which data come from slist x, example) A@VM@B@VM@C when try to readnext, what data read form data set wether just A or whole data by one filed? ----- Original Message ----- From: "R...