My select attempts to return all records from the QA system which are not in the Dev system.
SELECT QA.updated3,QA.acctid,QA.timestamp,QA.postingseq
FROM AS400.ABODATA.d3p004 PR
LEFT OUTER JOIN as400dev.abolib.d3p004 DV ON
QA.updated3 = DV.updated3 AND...
Announcement
Collapse
No announcement yet.
Search Result
Collapse
48 results in 0.0586 seconds.
Keywords
Members
Tags
-
query multiple databases on multiple servers
-
Mimix Replication SLA Reporting
I have a contracted SLA for Mimix replication but struggling to come up with a way to measure that the source and target systems are up to date. Mimix audits could be an option but the systems are still quite new and setlling down so we always have some errors picked up.
Any ideas?
-
Record level access iSeries <-> pSeries
Is there a standard way for an RPG program running on a V6R1 iSeries to pass a key value to a pSeries machine and then pSeries will return a record back to iSeries RPG program.
The pSeries will need to take the key value and sum dollar amounts and pass back at least two summed values to iSeries....
-
Looking for an alternate Scheduling and monitoring tool for iSeries
Folks,
Our shop is looking for an alternative solution for job scheduling and system monitoring . Currently we are using the Halcyon software which has both the provision(job schedule & sys monitoring) . I know there are a few vendors who has applications with both these features...
-
Indexes & Stat Maintenance
I am looking for a good whitepaper on Indexes and Stats for V7.1. Coming from SQL Server I am use to checking the fragmention level and reorganizing or rebuilding the indexes and also running stats. I am at a lost for how the iSeries handles index maintenance and how to check fragmentation levels....
-
Xml functions
What am I doing wrong with XMLCAST? I get "S1000(-20338)[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQ20338 - The data type of the XMLCAST specification must be XML. (1.55 secs)". This has to be something easy that I am missing, XMLGROUP returns an XML datatype so I don't get it....
-
Function Job Log
I have this function that checks if a date is valid. Every time a date is invalid the sql exception occurs and fills my job log. Any ideas on how to keep this out of the job log?
CREATE FUNCTION testyt.ISDATE (
@DATE VARCHAR(10) )
RETURNS CHAR(1)
LANGUAGE...
-
Estimating Size
I have a few tables that I would like to estimate the size savings on if I drop a few columns. What is the best way to estimate the savings?
-
Decryption on iSeries
Hi
I have a requirement to decrypt some field on web browser and direct it to as/400.
Do we have any way in which we can decrypt the text on iSeries.
Thanks,
Vivek Sharma
-
Data Area (Decimal) - Read/Write/Increment for Unique Running Number
Hi guys,
I have this assignment that required me to do the followings,
- To retrieve a Next Transaction ID from Data Area (Decimal)
- To use that ID in a SQL Insert Statement on a specific table on the same system
- For a successful insert (committed), the value of Transaction
-
Program Between Systems Runs Slow
I have two iSeries sytsems A & B both on V7 and one SQLRPGLE program. The program is mostly SQL. When it is compiled on system A and runs on A it completes in a matter of minutes. When it is compiled on system A and runs on B it appears to be stuck on a SQL statement. It sits there for hours and...
-
Contraint does not have a matching parent key
I have two table as defined below
TABLE 1
--COLA
--COLB
--COLC
TABLE 2
--COLA
--COLB
--COLC
Table 1 COLA is autonumber.
When I try to run
...Code:alter table TABLE2 add contraint CSTID foreign key
-
4 Tips For Unlocking The 400 Database
At the core of every AS/400, iSeries and IBM i is the DB2 database tightly integrated into the operating system. If you work with the 400 for any length of time eventually you will end up diving into the data stored within the database tables, usually to update a field correcting inaccuracies or other...
-
emulator for practice
I am new to AS400.So i need to practise a lot at home.Can anyone suggest me free emulator to work in AS400,RPGLE etc.
-
AS/400 Computer Operator - Tampa, Florida
Status: Full-time
Hours: 4pm - 12am
Start date: ASAP
Local candidates will only be considered for this position.
Will perform routine operation functions which include submitting jobs, monitoring messages, labeling/storing tapes, managing job/output queues,...
Our Sponsors
Collapse
