Archive for the Uncategorized Category
LANSA WEB EDITOR SETTINGS
3. April 2008 by admin.
SYSTEM: MYAS400
PARTITION: DEM
USERID: QOTHPRDOWN
PASSWORD: MUST TYPE IT IN ON OLD PASSWORD
**Make sure listener is running (STRSBS DC@PGMLIB)
**don’t forget to start the http server dc@pgmlib butthead
Posted in Uncategorized | No Comments »
SQL to show Deposits by Client in Rita
3. April 2008 by admin.
SELECT BATCH_SEQ_NUM , CLIENT_ID ,sum(int( TRANS_AMOUNT )) FROM
ritadb30/request WHERE STATUS_CODE = 2 and CLIENT_ID = ‘100300001′
and command = ‘COMPLETION’ GROUP BY BATCH_SEQ_NUM, CLIENT_ID ORDER
BY BATCH_SEQ_NUM desc
Then subtract
SELECT BATCH_SEQ_NUM , CLIENT_ID ,sum(int( TRANS_AMOUNT )) FROM
ritadb30/request WHERE STATUS_CODE = 2 and CLIENT_ID = ‘100300001′
and command = ‘CREDIT‘ GROUP BY BATCH_SEQ_NUM, CLIENT_ID ORDER
BY BATCH_SEQ_NUM desc
Posted in Uncategorized | No Comments »
Problems connecting to config400.exe?
3. April 2008 by admin.
Not able to connect to database withDB2 Driver on RiTA IP Configuration, Changed from DB2 to AS400 Connection
jdbc:db2://localhost/ritadb30
com.ibm.db2.jdbc.app.DB2Driver
Changed to:
jdbc:as400://10.23.0.22/ritadb30
com.ibm.as400.access.AS400JDBCDriver
Posted in Uncategorized | No Comments »
Helpful SQL Commands for RiTA
3. April 2008 by admin.
Wipe out data in TEST environment
UPDATE RITADB30/REQUEST SET BATCH_SEQ_NUM = -10002, STATUS_CODE = 7
WHERE CLIENT_ID = ‘100010001′
Batch Sequence
select * from ritadb30/merch_term_btch where client_id = ‘100010001′
UPDATE RITADB30/MERCH_TERM_BTCH SET BATCH_SEQ_NUM = 20 WHERE
CLIENT_ID = ‘100010001′
Posted in Uncategorized | No Comments »
How to compare files and create table of diff db2/sql
3. April 2008 by admin.
drop table mmason/yyckevents
CREATE TABLE MMASON/YYCKEVENTS like mmason/xxckevents
Table YYCKEVENTS in MMASON created but could not be journaled.
(creates an empty table)
INSERT INTO MMASON/YYCKEVENTS SELECT * FROM mmason/mmckevents a
WHERE not exists (SELECT 1 FROM mmason/xxckevents b WHERE a.EVEMPN
= b.EVEMPN and a.EVSEQ = b. EVSEQ and a.EVTIME = b.evtime)
1 rows inserted in YYCKEVENTS in MMASON.
Posted in Uncategorized | No Comments »