DSXchange

hello Amos

just finished it. man, i dont recommend it. The only problem I have now is to know why the uvrpcd process needs to run as root?

yes, all subsequent connections are dsadm processes, but dsadm cannot start the server, but can stop the server.

Hallo all Im getting grey hairs trying the above, and just need a few things answered.. 1) Does anyone have a succesfull non-root installation on solaris 2.9 1.1) if yes, what is the trick. We seem to go by the book, but no luck. The installation fails when attempting to create the projects (of whic...

The CFF does support occurs depending on , but it helps if there is a maximum occurs in the file definition. From the above, one could try to be clever :idea: and accept that the columns until the occurs depending on will be defined. that means that if the first columns are 53 in length, that would ...

Hi all We have a download from the mainframe in ebcdic/binary format. This means that we need to know the length of the record to determine when the next record starts - i.e. no CR/LF to do that for us. We are reading each record in as one column (or at least, thats what i want to do), because i onl...

we actually had trouble calling the sdk transform - simply because we didnt know the syntax. So, from reading here and there we eventually found that by saving the transform to examples/functions we could call it using: DSU.CopyOfTransformNowInExamplesFunctions What is DSU? How could I avoid using D...

hi Mathias How to deal with the EBSDIC-Code issue? We are also getting db2 data and currently we are using the CFF to read the data. The data is downloaded in binary . Try avoid the temptation of appending CR/LF at the end of each line when FTPg the data to your server. I have not hit a NULL charact...

again! i am in need of assistance.

We want to call a sdk_transform from within a user defined routine AND want to use the value returned from the transform within the routine.

i.e.

from the above, we want to use the value returned in the rest of the routine.

Hi Morney Looking a little better - I have it working (almost) on my pc. i.e. if i import metadata for a table on db2 its working. now, when i want to view the data i get error messages that disappear as soon as i remove the derivation... which i have just fixed by importing the metadata checking &q...

hi morne we all have the dll required. i asked the developer to log in from my pc and test and no luck with the data. Im getting unable to initialize plug in when trying to import db2 plugin metadata - think this could have anything to do with it? ive tried 3 times now to reregister the plugin (usin...

hallo! Ray - ozzies won a tough match on saturday. well done to gregan and his men. I get the following error when accessing db2 data (well, I try). ds_loadlibrary: Win32 error in LoadLibrary of dsdb2.dll - The specified module could not be found. The set up is as follows: we connect via DS clients ...

Hi morne The server job CFF also does this, except that you need to specify for obvious reasons the maximum occurs in an 'occurs dep. on' field. else, if you have int(4) as your occurs defined field there is a possible 9999 occurs if the maximum is not defined. When we eventually start developing on...

It will be good to see, and I'll go check out IBMs site - but you should see Sybase IQ at bulk loads.. man, its impressive. Ive seen it at 100 000 rows per second. :shock: and then the queries are just as fast. I once was blind, but now can see :!: and then theres this... EVERY column is indexed :!:

ray.wurlod wrote: Get Red Brick Warehouse! World's best bulk loader, and automatic maintenance of aggregates.

Ray, I'm interested - Do you have a site with performance stats on the bulk load? I'd like to compare it to Sybase IQ bulk loading.

The solution...

dont use -hyphens- as seperator between words for a column, rather use _underscores_

hallo all hows this one! CFF stage --> Transform --> SeqFile In the transform, the CFF columns are to be dragged across as is and written to the SeqFile. The links in the transform refer to Linknn.colname which are correct BUT the link is not displayed - its all in red now.. when we take the CFF and...