Is there a difference bwteen selecting rows in the WHERE clause on in the JOIN clause.
FROM orderHdr t1
JOIN orderDtl t2 on t2.orderno = t1.orderno
I'm creating a simple Access frontend for a DB2 table. Using the following code updates the contents of the pass through query correctly but fails to execute the query. What do I need to change to get…
We are on DB2 Linux 9.7 database version.
I have a Stored Procedure which returns a result set. I need to store that result set into a table.
How can i do it?
I have installed Client Access (7.1) on our MS SQL 2014 server. I am using the IBMDA400 OLE driver to create a linked server to DB2 database one the iSeries. When I run a select statement on the data…
We are on DB2 Linux 9.7 database.
I have a Stored Procedure, which passes the client's first name, last name, DOB and SSN, to retrieve client's information.
In the below query, the …
i want to check if the Windows server has the following software installed on it.
I believe we can check this if there are services …
This is an ongoing project to sync Office Vision on a 610 (v4r5) to backup system a 170 (v4r4).
We did a full system save of the main system and restored it to the backup system, changed license …
LPSDT and LPFDT are date and time stored as Packed Decimal. I am attempting to extract the information out and put it in time format and calculate Time Spent.
Update: I'm trying to sync office vision email changes between to old systems for recovery purposes. Office vision is the only application running both systems: active system is a 610 v4r5 and the …
Our shop has not used journal until a couple months ago when I added them to a couple master files for audit trail purpose. So, my experience with journaling is very limited. I don’t mind …
I had this question after viewing How to remove table from super exclusive lock in db2 (https://www.experts-exchange.com/questions/26449737/How-to-remove-table-from-super-exclusive-lock-in-db2.html).
I'm asking this for a co-worker. He has been tasked with migrating data from an IBM AS/400 iSeries DB2 database to a MS SQL 2016 environment. He tried to use the Microsoft SQL Server Migration …
I have two tables join as below giving results as below:
from ps_check a
left outer join ps_earning b
I have a SQLRPGLE program that has to insert thousands of records (possible from multiple instances)
If the file is full (Msg CPA5305) the program will wait until the QSYSOPR message …
I'm trying to make a bash script (oslevel = AIX 7100-04-02-1614) that's going to restore my DB2 database from an existing backup into a different database (DB2PRD3 - DB2PRD4)
below are the …
I have table as below:
emplid effdt date_of_birth
123 2016-01-01 1950-01-01
234 2015-01-01 2000-01-01
result should be:
We need to start using a new tape each night for the backup and keep these tape indefinitely (long story). I would like to have BRMS use the tape without enrolling all the tapes. Can I do …
I'm attempting to use a form instead of InputBoxes to grab the data for the variables in my VBA code. This code opens the form but throws error 424: Object Required. I'm not sure how to call the form …
I have column textcode in many tables I want to find which tables have that column how can i do that.
I am using MS Access as a frontend to a proprietary DB2 database that resides on an iSeries. I have VBA code that I am using to run a QueryDef for a pass-through query and this code prompts the user …
Is there a way to trigger a prompt for input from a user in DB2 SQL? Currently, I am running Pass-Through Queries using Microsoft Access as a front end and on some of my queries I need the flexibility…
I need to query my inventory and select all records for all items where 1 of the records for the item has a last received date older than 20160201. My inventory contains over 11,000 items.
The following query grabs data that I need to pivot but Max and Sum don't play well in the same sentence so to speak. Stubborn Aggregates. I have tried various sub selects but the results come out …
I have data as below
I want result like
I am a a Oracle dba with an issue with a DB2 database system.
The DB2 generates files *.LOG located in a specific drive, and sometimes the drive is running out space.
There are files…