DSXchange

When you highlight the rows to do your deletes, make sure you are in the row to the far left, the one that is empty except for the arrow. If you click in that spot, it will highlight the entire row. Then move down to the final row and click in that same spot while holding down the shift key. That wi...

Off course, thanks for the help David. This will definitely save me some time and effort. Regards Dirk -----Original Message----- From: David Barham [mailto:david@barham.hm] Sent: Wednesday, October 31, 2001 1:37 PM To: datastage-users@oliver.com Subject: RE: Deleting column definitions Use the top ...

Use the top half of the window, not the bottom half. -----Original Message----- From: Dirk Moolman [mailto:dirkm@reach.co.za] Sent: Wednesday, 31 October 2001 9:17 PM To: datastage-users@oliver.com Subject: RE: Deleting column definitions I tried this in the transform stage now, but it does the same...

I tried this in the transform stage now, but it does the same there as in the sequential and odbc stages. I still have to delete columns one by one ...... unless I misunderstood you somewhere ... Dirk -----Original Message----- From: David Barham [mailto:david@barham.hm] Sent: Wednesday, October 31,...

The trick is to go to the transform end of the link and delete the columns in the transform stage. Deleting, cutting and pasting are much more useful in the transform stage. -----Original Message----- From: Dirk Moolman [mailto:dirkm@reach.co.za] Sent: Wednesday, 31 October 2001 5:30 PM To: datastag...

I tried this, but it does not work on my version. I am using version 4.2 on Windows 2000. I am working with sequential and odbc stages. Dirk -----Original Message----- From: Peter Oates [mailto:Peter.Oates@macquarie.com] Sent: Wednesday, October 31, 2001 9:12 AM To: datastage-users@oliver.com Subjec...

Hello Dirk,

which stage did you use? We use OCI in DataStage 4.0 and have no problem by deleting a range of columns in on step.

rergards
Udo

Dirk, Highlight the first row, move to the last row and do a shift click to highlight the whole table. Press delete and all rows will be removed. Peter -----Original Message----- From: Dirk Moolman [mailto:dirkm@reach.co.za] Sent: Wednesday, 31 October 2001 5:55 PM To: Datastage List Subject: Deleti...

Hi, I am busy creating a lot of jobs which are very similar, so what I do is to copy jobs and then change the detail inside the jobs. Under the columns tab I then have to delete all the column definitions from the job I copied and load a different table. How can I delete all the columns in one delet...

Hi, I use UDB load stage in DS ver 4.0 to load the data into DB2 database but I could not load the data into DB2 database, which runs AIX server and DS gives me the following Warning/Error messages. Job name is - LOADKFPersonalStg UDB stage name is - UDBLoad3 1. LOADKFPersonalStg.UDBLoad3: ERROR occ...

Pedro, I tried using Type 25 type files for lookups for this reason before and got a core dump. I will try again. If you want some consulting then we may be able to help also. We have a number of DataStage consultants available in New Zealand and if the logistics can be worked out then the NZD is ch...

Have you tried to increase the amount of virtual memory, by doing so you are increasing the disk space that the swap file can take in the HD, idont know if that will solve your problem but is worth to give it a shot. >From: "Alessio Giordani" >Reply-To: >To: >Subject: Unable to create temporary cach...

Hi All, May be this has been discussed before. From what I have gathered, routines are externally linked to the program whereas transforms gets natively compiled with the code. My question is what happens when we have a transform which calls a routine? YN ____________________________________________...

Hi all, Im working with DS 4.0.2 on NT4.0 platform. Executing a job with many hashed file with more then 5 pre-load in memory option checked, I have a log message like this for every pre-load in memory exceeded: JobName.HashStageName.LinkName: add_to_heap() - Unable to create temporary cache file. C...

Pedro, were done this before in data stage, doing dialcode lookups against worldwide dial codes. This is quite a hard thing to do, because as you said, dialcodes differ between countries (on style and length) on a dialled number you have no idea what part or how much of it is the number and how much...