Josh Hull

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...
Josh Hull
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)...
Josh Hull
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...
Josh Hull
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...
Josh Hull
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...
Josh Hull