DSXchange

RPC Port for DataStage 6.0 on UNIX is 31538


-----Original Message-----
From: Rui Soares [mailto:rui.soares@novabase.pt]
Sent: Friday, November 08, 2002 12:10 PM
To: datastage-users@oliver.com
Subject: DataStage port


Hi,

Wich port use Datstage to work ?


Regards
Rui soares

Hi,

Wich port use Datstage to work ?


Regards
Rui soares

Hello; We are planning to upgrade our DataStage from 4.1 to 6.0. Can any one please share experience with it? 1. All the 4.1 jobs are compatible with 6.0? 2. Installation/Upgrade problems? 3. Find any performance Diff.? 4. Above all, is it worth it? Thanks in advance Regards Rahim Ladha e-mail : rah...

What I want to say is how you save the value into the hash file. So, if you search a portion of string you have to use this sintax "ValidData MATCHES ...2002-11-28..." (with dots), otherwise "ValidData = 2002-11-28". I suggest you to verify if there are leading or trailing spaces. Regards Riccardo -...

Tom, The hash table fields have no concept of format or dates. The raw data is either stored as a number of char. The date will be stored as a char and so when selecting should be treated as such. The actual string for comparison must match identically that stored, including any trailing spaces etc....

no, its defined as a Date with length 10. Ive forgotten how to make Command Output from the DS Administrator screen write to a log.file on my drive - so if you could remind me, i can write you a full result from my "LIST DICT" command The field is defined as follow: ValidDate I FIELD(@ID,@TM D, 2) a...

Hi, how did you define that field?? is it a timestamp format?? Riccardo ----- Original Message ----- From: "Tom Peter Nielsen" To: Sent: Friday, November 08, 2002 12:57 PM Subject: Re: SELECT on date from UV stage > Thats what im trying, but it doesnt work. > > in the selection tab i put in the text...

Thats what im trying, but it doesnt work. in the selection tab i put in the text: ValidDate = 2002-11-08 and it find no data. If i change the selection criterias and search on one of the varchar fields instead - it works. So i think its processing the date format in the wrong way. (or im typing it i...

Hi Tom, yes you can filter data using the "Selection" tab into Hash File stage properties. Hope this will help you Riccardo ----- Original Message ----- From: To: Sent: Friday, November 08, 2002 11:57 AM Subject: SELECT on date from UV stage > Hi, > > I have a hashedfile with 3 fields > OldValue, va...

Tom, To check if the hash file already existing try to open it using the open command, using the else clause for the create statements. Also in routines you do not need to use DSExecute you can Execute which executes a DS command from basic. The Execute command will give you greater flexibility when...

Hi, Installation: DS 5.2 on AIX Ive made a routine that can generate Hashedfiles, but when i try to create a file that already exists, it aborts. How can i catch the error and how should i handle it in the first place ? is the solution to check if it already exists, or are there any other options ? ...

Hi, I have a hashedfile with 3 fields OldValue, varchar NewValue, varchar, (KEY) ValidDate, date, (KEY) NewValue and ValidDate are is defined as KEY fields, and the data looks fine when i look at them with viewdata. How can i make a where clause that lets me search for data with a specific date This...

Tim, as of version 5 you can elect to have a global shared memory area for all hash tables. This creates a single area of memory into which all hash tables are placed. If you are concerned about memory usage it may be an idea to make use of this functionality. The other advantage is that if the hash...

This can only be accomplished on a project-wide basis (at DS 5.x). Open the DataStage Administrator, select your project, and click Properties. Once there, choose the Tuneables tab, where you can set the read cache size and write cache size for hashed files. ----- Original Message ----- From: tim_wa...

Hello All, I have a few real small tables that I am hashing (20 records at approx 100 bytes a record). Im using the Type 14 Hash File. I get the following message in the DS Log when I call the hashfile in a job. Message: P10StgsalesintFromStgsalesextractint..HSH_STGPRODHIER_BASE.HSH_PRODCOLOR: Read ...