DSXchange

Ray, CAST .. AS VARCHAR2, CAST .. AS VARCHAR, string[1,xxxx] and Left(string, xxxx) work as long as xxxx value is 1999 and below. Any number above 1999 results in ORA-01461 error ( ORA-01461: can bind a LONG value only for insert into a LONG column) I tried dbms_lob.substr on the source table and it...

DSGurus, After reading up on all the posts, related to this issue, I'm posting this new thread. I've a job with Oracle DB table as source and target. The source table has a CLOB field with a maximum of 7600 chars. We want the job to typecast CLOB to Varchar, split them and populate it in two separat...

Any help from anyone is very much appreciated!

Thanks,
Mav

Missed this one-

When I chose ORAOCI9 from Plug-in Meta data import I get

Error calling subroutine: DSR_IMPPLG (Action=1); check DataStage is set up correctly in project DWDEV
(The connection is broken (81002))

and

There are no registered plug-ins that support meta data import

Thanks

Hello, I tried to register ORAOCI9 plugin and I got the below error: The 'ORAOCI9' Plugin being registered is an older version than the one already installed in this project. The existing version of this Plugin must be unregistered before this new version can be registered. I tried to unregister but...

We used to face this issue on a regular basis. The fix that worked for us was - reducing the number of DS jobs that run concurrently. Hope this helps.

Ray, I didn't get an email notification when you replied and yesterday I ended up just manually deleting the VOC entry, the hashed file directory and D_hashed file. I thought of updating my thread now and I saw your response. Unfortunately couldn't give UVFIXFILE a try :( Anyways, thank you! @Others...

Ray, I'm trying to clear a hashed file created by our project. Here are the permissions on them: /ps/dsadm/Ascential/DataStage/Projects/DWDEV> ls -l | grep BLAH_BLAH -rwxrwxrwx 1 dsadm dsadmdev 2048 Jul 22 13:06 D_BLAH_BLAH drwxrwxrwx 2 dsadm dsadmdev 4096 Jul 22 13:02 BLAH_BLAH /ps/dsadm/Ascential/...

Hi Craig, Just checked now, without making any changes, and got the same error. /ps/dsadm/Ascential/DataStage/Projects/DWDEV/BLAH_BLAH> ls -la total 650184 drwxrwxrwx 2 dsadm dsadmdev 4096 Jul 22 13:02 . drwxrwxrwx 42929 dsadm dsadmdev 2101248 Sep 30 15:02 .. -rwxrwxrwx 1 dsadm dsadmdev 561053696 Oc...

Hello Gurus, I'm trying to clear a hashed file but I get the following error: /ps/dsadm/Ascential/DataStage/Projects/DWDEV> uv 'CLEAR.FILE BLAH_BLAH' CLEAR.FILE attempt on read-only file. ** CLEAR.FILE processing aborted. ** At the OS level, the directory and *.30 files have RWX permissions. This is...

Hello Gurus,

Sorry for my slow response. I'm swamped with production issues and will update this post next week.

Thanks for your patience
-Mav

SURA wrote:Partition.

Do server jobs load data in parallel into partitioned Oracle tables? I really doubt that!

@Craig, "after going 'round and 'round talking. Wink " Sorry about that. Next time will follow your advice promptly :) "2) For Server, that's what I've always done. I'm assuming your hashed file just has the keys you need and the CRC32 value, yes? Do you persist it in the target?"...

@Ray - "Even flash disks can perform better than spinning disks." By Flash disks do you mean USB flash pen drives? @qt_ky - "Is that what you are asking--persistent caching across job runs? If so, have you run any test to see if it appears to be cached across jobs or not?" My que...

@Eric, Sorry for my late response. By Catalog I presume loading a Hashed file into memory. Please read through "Disk Caching Guide" manual for more information. I'm still an amateur in this topic and hence I'm trying to get clarifications from DS gurus by asking a lot of (possibly dumb) qu...