-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am comparing some CHAR data in a where clause in my sql like this,
where PRI_CODE < PriCode
The problem I am having is when the CHAR values are of different lengths.
So if PRI_CODE = '0800' and PriCode = '20' it is returning true instead of false.
It looks like it is comparing it like this…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm trying to generate a blank docx file using Java, add some text, then write it to a BLOB that I can return to our document processing engine (a custom mess of PL/SQL and Java). I have to use the 1.4 JVM inside Oracle 10g, so no Java 1.5 stuff. I don't have a problem writing the docx to a file…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
If you ask a DB2/zOS engine DBA a question about DB2's behavior, the DBA will refer to the DB2 engine as "he" much the way a sailor uses "she" to refer to his ship.
For example: "Once you fill the freespace, DB2 still wants to keep those rows in cluster order in the tablespace. That's why he'll…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
Hello,
I'm getting following error when using Hibernate in a Java application over my DB2 database.
This error occurs with one DB2 database and not with another (I'm almost sure the problem is in DB2 server side configuration), and I didn't found the difference between the two databases.
The SQL…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
How can I associate a UID to a specific username on IBM z/OS Unix System Services?
Within USS, I see content created in my user space which I do not own. File ownership lists a three digit numerical value, rather than a userid, which I presume to be a UID. I've unsuccessfully attempted to make…
>>> More