StackOverflow is a collaborative programming Q&A community venture
Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.
Db2 Driver/Datasource setup on wildfly: Failed to load module for driver [com.ibm]
I am wanting to configure the data source for db2 on my wildfly server (Wildfly.8.0.0-Final and 8.1.0 as well.) and am running into some problems doing so.
My research tells me this is a two step process
So far I have installed the module under the following structure with the following module.xml:
There is no space before the
The loading up of the server produces this error:
Which in turn causes my datasource declaration to fail loading as the driver is missing.
I am using older documentation as a guide because there doesn't seem to be any available for wildfly as yet. this documentation shows some promise but it seems a little out of date. If anyone has had any experience setting this up then Your help would be much appreciated.
I want to connect to DB2 9.7.
Please and thank you.
No authorized routine named "SYSPROC.CE_UPDATE_DETAILS" of type "" having compatible arguments was found. .NET CORE-DB2
I am trying to run DB2 Stored procedure from .NET Core 1.0 on a windows machine. but facing exception as mentioned in title. when i mention simple select statement in command text , it works fine.
Select a row with Max Date for set of account number
I have a table with three columns, ACCT_NUM, EFF_DATE and ACCT_NAME. Unique keys are ACCT_NUM and EFF_DATE.
and more accounts.
Want to get latest account name based of Eff_date for a set of account numbers using in clause.
like to get following data,
Convert dd-mon-yy string to date in DB2
in DB2 I've got DATE values stored as varchar in the form
e.g. I've tried
Does anyone know if there is a format string that I can use?
How to create a user defined function that returns a table in a DB2 module?
I am trying to create a user-defined function that returns a table in DB2. Here is what I have so far.
This is a table that I use:
This is a user-defined function that returns a table (which is working fine):
This is a how far I was able to get with the module:
Any attempts to actually add a function to a module failed with various errors. Here is my DB2 version information: Database server = DB2/LINUXX8664 188.8.131.52This is an Express-C installation under Redhat.
When I try this, I get SQL0628N Multiple or conflicting keywords involving the "RETURNS" clause arepresent. LINE NUMBER=16. SQLSTATE=42613
When I try this (removed RETURNS clause), I get SQL0491N The CREATE FUNCTION or ALTER MODULE statement used to define"CORPDATA.MODULE1.DEPTEMPLOYEES" must have a RETURNS clause, and one of: theEXTERNAL clause (with other required keywords); an SQL function body; or theSOURCE clause. LINE NUMBER=8. SQLSTATE=42601
When I try this (removed BEGIN ATOMIC), I get SQL0104N An unexpected token "SELECT" was found following "INISTICRETURN ". Expected tokens may include: "(". LINE NUMBER=9. SQLSTATE=42601:) Yes, it does say "INISTIC".
Is there a way to Concat multiple rows into one but keep each column value as a seperate column?
I know that it is possible to almost do what I want with LISTAGG however that adds all of the values into one column.
For example if I have something like this
I am hoping to get something like this
How to write DB2 SELECT statement in unload job for delimiters
I have been over this... seems silly but couldnt figure out!
I wanna UNLOAD a table but with a delimiter '|' in between the fields. Here is the JCL used to unload the table:
But I wish to have like below
I'm not able to figure our why that .. is preceeding the delimiter '|'. Any guesses what does that value mean? Thanks for your interest.
SQL like with multiple characters
I'm trying to perform some selects in DB2 SQL, using the LIKE command, specifically looking for values that start with certain multiple digits. I thought I was using the expression correctly, but I keep getting syntax errors and I'm not sure where I'm going wrong.Right now I've been trying:
Am I just using the wrong SQL for the environment? (This is polling DB2 for Zo/s) LIKE doesn't seem to work when I just try a single 8% or 9% either.
I appreciate any shared experience, thank you!
SQL Query to concat duplicated row
Let's say I have a table with 3 columns with the following values
I'd like to make a query to get
to get distinct First & Second Column. Any help would be greatly appreciated
db2 prune history timestamp and delete having no effect?
I need your help with this one: I'm on db2 luw 10.5.8 and have set logarchmeth1 to tsm. I noticed my logpath is getting full (only 10% of available space left) and so I decided to use the db2 prune history command to free up some space.
Here is the command I used:
I was under the impression that this command would free up some space by deleting all logfiles prior or equal to the specified date. Unfortunatley it didn't work that way. The available free space in my logpath remained unchanged at 10%.
I also tried the depracated prune logfile command (same result):
What can I do to free up some space in my logpath?Any ideas?