DSXchange

Hi Folks, We have a programmer here who has created a hash file where the first field has not been defined as the key column. The hash is being used in other jobs and the jobs seems to be working fine. I was under the impression that the key field(s) has to be defined as the first column(s). Can any...

Dinesh, I think the HashedFile stage, when reading a field containing just byte 0x80, should be setting the corresponding variable in DataStage to an internal NULL. It obviously isnt in your case, but Im not sure why. A variable that is set to internal NULL, and a variable containing a string with j...

Wait a while (but dont know how long ...) or type (in upper cases!) following commands in DSAdministrator (select your project then "Command") : LIST.READU EVERY This will give you the device (XXX) and the inode (YYY) number of the lock of your job LOGTO UV (dont care about error message) UNLOCK DEV...

Hi Could anyone tell me of any books/documentation regarding datastage administration using the VOC ie using LIST.READU EVERY etc -----Original Message----- From: Kasia Lewicka [mailto:katarzyna.lewicka@cgey.com] Sent: 29 August 2002 16:30 To: datastage-users@oliver.com Subject: Re: Reset Job when W...

Hi Tim In redbrick we set the following parameter for the datastage user (in the dsenv file): DISABLE_INFO=YES; export DISABLE_INFO This stops pop-ups/messges etc from being sent to datastage which it cant translate to text. Perhaps there something like that which should be set for your user. Denzil...

Wait for Elavenils reply - would he prefer the French or the English version... Anyway, could you send me your English version, its ever better to have one. Thanks Kasia At 14:35 29/08/2002, you wrote: >Kasia, > >monde bizarre, jen ai une document *.pdf concernant Hfiles en anglais >(UniVerse System...

Hi,
You could use @NULL in a test instead of isnull function.

PYB.

Hi Sharon I got this once as well, and this is what was sent to me - Im sure it will help. To do this, you must have job adiminstration enabled from administrator. Open the Job Resources dialog box by doing one of the following: Choose Job > Cleanup Resources from the menu bar. Choose Cleanup Resour...

Kasia, That "wait awhile" is for the deadlock daemon (uvdlockd) to discover that the lock was orphaned and clear it. uvdlockd is part of pre 5.x releases. Alan > > From: Kasia Lewicka > Date: 2002/08/29 Thu AM 11:30:12 EDT > To: > Subject: Re: Reset Job when Workstation Goes Down > > Wait a while (b...

This is a topic for an orphaned message.

Sharon, When you use Designer, you set a lock on the job. That lock is still set when you terminate your DS connection. If you have Administrator rights, you can use the DS.TOOLS menu to manage the locks. Once the lock is cleared, you can bring the job up in Designer again. Alan > > From: "Sharon As...

Good evening from good old Europe, Sharon, First approach is to be patient, when viewing you want to see them and when you have conditions in the stage it takes time. Ive already waited with success for an hour. If you have set up in Administrator the possibilty to Cleanup jobs in director, you can ...

Ray, My outfile is text file and I am using notepad to view it. We are getting 0x80 (decimal 128) character in the output text file. I tried to use Isnull function in the transformer stage but it also fails if hash file is sending 0x80 character as output. Any thoughts on suppressing this character?...

We have an issue were a job was created and works perfectly on our Development and Test servers. Unfortunately, when we migrated over to our Production severs last night we received the following error: P023StgenttrlFromStgenttrlint..LKP_STGENTTRL: Error while trying to retrieve text for error ORA-1...

I have a document about HFiles from Ascential, but it is in French - do you speak French? Kasia At 09:37 29/08/2002, you wrote: >Hi, > > > >How do i create static hashed file? and what is the difference between >static & dynamic hashed files? Please advise when to use static & when to >use dynamic. ...