Josh Hull
5 questions
1
votes
0
answer
930
views
Spring SimpleJdbcCall Oracle sql/pl - Unable to determine the correct call signature - multiple procedures/functions/signatures
I have a stored procedure in a package which has it defined with three different method signatures in the same package. They vary by only a few parameters (each calls the next with a few default values). I've over-simplified the list of columns for the sake of brevity here. I have about 55 fields...
1
votes
2
answer
1.3k
views
HEX TO RAW function for DB2 on z/OS
I need to cast an INT value as HEX (not to hex).
For example, given the value 1234, I want to transform it to x'1234'.
My first inclination was to use the hex function, but that does not produce the desired results:
hex(1234) = x'04D2'
I need a function or algorithm such that
my_function(1234)...
2
votes
2
answer
4.5k
views
How does the HEXTORAW() function work? What is the algorithm?
HEXTORAW is a function found in several RDBMS's like Oracle, and DB2 on LUW. It takes a character, or integer input, and basically casts it to a HEX value.
HEXTORAW(1234) = x'1234'
What is the algorithm for this type conversion? What is happening in the code behind the scenes?
(This is motivated...
2
votes
0
answer
668
views
How to configure logging in JBOSS EAP 6.3 / AS 7 by .war name
What is the new strategy to configure JBoss EAP 6.3 / AS 7 with deployment specific settings, but without modifying the .war/.ear? (By modifying the deployment file you could do it by including a logging properties file or by specifying a logging profile in the manifest).
It was previously possi...
2
votes
1
answer
1.5k
views
How to get DB2 MQT last refresh time
For a DB2 on z/OS Materialized Query Table, how can you retrieve the last refresh time?
The documentation states that one of the actions that DB2 takes during a REFRESH is to populate the catalog with a refresh timestamp.
Updates the DB2 catalog with a refresh timestamp and the cardinality
of the...