DSXchange

This is a topic for an orphaned message.

Logged in as Administrator, in the UV "project" (account) or in a project in which DS.TOOLS options to administer locks/processes has been executed, use LIST.READU to determine the user number of the owner of the lock (even though this may be a defunct user) then use the UNLOCK command (in the form ...

Recent interruptions in the availability of the forum have been due to system level problems(security) and not site maintenance. We are currently working on strategies for higher availability of the forum. We have moved some sections to our new site, www.datastagexchange.com, and are evaluating opti...

Hi, have you tried to unlock the process connecting via telnet/administrator and using DS.TOOLS? I think DS.TOOLS is the best way to unlock processes. Hope this help Regards, Riccardo ----- Original Message ----- From: "GEORGES DAHER" To: Sent: Thursday, December 19, 2002 9:14 AM Subject: Olck on Ha...

Hello ! I need to create a job (job sequencer or job control) which access a Database, get a value (a date) from a table in this Database and then sequences an other job with this value as a parameter. I havent seen a way to do this in a job sequencer yet. Is there a way to get a value and pass it t...

In older versions of DataStage (3.6, perhaps even 4) the key have to be always as first columns of the hfiles. At 06:40 19/12/2002, you wrote: >Hi, >I changed the key in a hashfile. >With "View data" I can see all data. > >I use the hashfile in another job. >With "View data" I cant see the second an...

Also look at the position of each colum in the lookup hash file. All key columns must have a value of 0 and non columns should have values starting with 1,2,.. and so on. And as Kasia has mentioned, the key values have to be the first consecutive columns of the hashed files for earlier versions of D...

sorry for the delay in my answer. In an earlier version of DataStage (3.6), weve encountered a lot of problems with hash files (jobs hanging, inconsistent data, ...) We then choose to delete and create the Hfiles each time the job run, and to prevent abort when creating file in case Hfile have not b...

Hi all Sometimes when a job aborts it locks a hash file and there is no way to release the lock, i tried too many ways like using the "Cleanup resources" and "clear status file". I also tried to go to the administrator and execute the command "DELETE.FILE xyz", i receive this message ((rm: (DATA.30)...

when you change the key fields of a hashfile you need to re-fill the file again. The keyfields will always be the first fields in the file - so you cant just change the order of the keys. br Tom -------------------------------------------------------- Tom P. Nielsen Project Masterdata Reg.nr. 4853 /...

Hi, I changed the key in a hashfile. With "View data" I can see all data. I use the hashfile in another job. With "View data" I cant see the second and fourth column (only the column name). There are emty columns between the right data. If I run the Job there is the following warning: DimensionSortR...

Ramesh, You have fewer columns in your source data than you are expecting in the DS job. The next row is used to fill out the shortened row. To verify, count the delimiters in each row and compare to what you are expecting. Alan > > From: ramesh pothuru > Date: 2002/12/18 Wed PM 04:43:17 EST > To: d...

If your second data record is wrapping onto the end of your first, you really need to double-check the way you have it defined in your sequential file stage. Pay particular attention to the new attributes each row can have (unless you are on a pretty old version), especially the Contains Terminators...

Ram, Are they dos or unix files (and end of line carriage returns)? If they are unix, how do they look in vi? If they are dos, how do they look? What happens if you try to import them into excel? Are the records all over the place as well? Can you send our a sample record or two so that we can see w...

Hi, I am loading flat file data to oracle tables. in flat file, each row ended with carriage written character. I assume, its file format, but some columns does not have data and has spaces(I believe nulls), so while viewing data in datastage designer sequential file stage, data is not showing prope...