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…
Emplid. Code. Period
123 744 3
123. 510. 3
123. 744. 4
123. 890. 4
123. 615. 5
123. 510. 5
I want to …
I have to filter based upon four columns emplid,empl_rcd,effdate ,seq filter is like 1000 rows in xls.
i can just do select can't create any tables etc.
i am doing
select * from tab
I have a PowerShell script that am using to connect to a DB2 database.
The script has the credentials hard coded at this point, and everything works fine.
I am trying to encrypt the password and…
When in DB2 95, I used to use DB2 Configuration Assistant to create and share the Database profiles and share them with other developers. With DB2 10.1, there is no DB2 Configuration …
I get an error with a SQL statement getting data in a DB2/400 database when the WHERE clause contains a LIKE clause where the content of the LIKE includes the star character, "*", and this in a …
We want to create materialized view in IBM i series v7R1 instead of normal views as we are having performance issue. Could anyone let us know how to create & maintain materialized view .