Search results for query: *

Passing hashtables between two java pgms usually is not a problem. The problem is when you define a java STP. You have to define an oracle package header. In that header, you have to map java types to oracle types, when you define the INPUT and OUTPUT parms of that STP. So far, I cannot...

Any idea on how to return a hashtable or vector from a stored procedure. Regards. Dan Pamintuan

Hello, I am very new to informix, and have been searching the doc in a effort to find a way to encrypt data within the database. With Db2 you can use exits to do this and with the newest version of udb has built in functions that do this. Is their someway to do this with informix 7.3.

Does anyone know how to force a log swtich in udb/6.1 on AIX.

I'm trying to do a redirected restore a db2/udb v 5.2 database on aix. There is no database on my target system. I keep geting the error "not enough memory". My aix system person, keeps telling me that there is more that enough 2 gig real ,4 gig virtual. With little activity on the...

I'm having a problem trying to FTP a file from one server to another. Once the file get to about 2Gig, I get an exception and the ftp dies. Also, if I compress the file, ftp it over, and uncompress it. Once the uncompress gets to about 2GIG, it also dies. There is plenty of space on my...

I'm running DB2/UDB v 5.2 on AIX. I know we should have upgraded already, but thats not my call. Anyway, I when looking at the db snapshot monitor, I see sort overflows but none of the sorthead allocated. I can't figure out why none of the sort heap is being allocated. The sorthead parm is...

In the unix enviroment I do something similar. I execute a query with a literal in it, use cut and grep, and pipe the file to a new filename. This new file has only the names of the tables in it. This all enclosed in a shell script that takes in variables such as instance-name ,dbname, and...

If you are using the load utility, of course it does not log. The import utility can be made to commit after so many records. I am not familiar with informatica, but if this is doing your loading via insert, then you have little recourse but to either use gigantic logs or create the targetr...

I've worked with both Oracle and DB2 as well. In my opinion, they are very similar to administor. There are several good books out there. I would recomend the db2 udb by don chamberlin and any of the certification guides that are currently available. Additionaly, if you go to...