Updating a VSAM file
Tim wrote in with this question recently: “I need to update a VSAM file on a mainframe connected to an AS/400 — via TCP/IP. Ideally, I would like to add/delete/update a record on the AS/400 and have the database issue a call to a CICS program on the mainframe, pass data to the CICS program [...]

Answer Question   |  November 21, 2009  2:28 PM
AS/400, DB2 Universal Database

Looking for a utility to list all used queries and files
Pat wrote in with this question recently: “I need a utility to list all queries and files used, date used, etc. I am on V5R1.” Can you point him in the correct direction? – Debra Tart , associate editor, Search400.com

Answer Question   |  December 15, 2005  2:20 PM
DB2 Universal Database

Oracle HA Database Architecture on Linux
Are there any high availability database architectural issues/options to be conscious of on Linux?

Answer Question   |  December 13, 2005  5:16 PM
Database, DB2, Oracle

Anyone ever use the SNDRPY command in CL?
I am using the CHGPF command to change a file. I know it will result in data loss, and I will get a messaage that I must reply “I” to ignore and then it will change the file. The file is used all day long and I would like to have a CL program change [...]

Answer Question   |  December 14, 2005  4:56 PM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE

Old Approach App in XP
Hello, Have an older Lotus Approach ’97 DB App here that I have been asked to see what it would take to get back working in our XP enviroment. This is about 10 Approach Databases in an relational type of setup with about 2000 records and 150 or so custom layouts. Have messed with it [...]

Answer Question   |  January 4, 2006  10:08 AM
Database, DB2, Development, Oracle, SQL

Procedure Error
Hi Friends, would appreciate if someone could let me know the error in the Stored Procedure. It doesn’t compile successfully right now and feel there is a mismatch between the ‘Begin’ and ‘End’ keywords. Pl. confirm. Thank You, Friend33 Create or replace procedure proc_name IS Pwd varchar2(8); user varchar2(8); v_email varchar2(40); FUNCTION new_password RETURN VARCHAR [...]

Answer Question   |  December 8, 2005  9:22 AM
Database, DB2, Oracle

Outlook – creating Contact Lists under one main List
I’m using MS Outlook 2000 SP3 (9.0.0.6627). My company has about 1,000 customers/offices that we support. I’m working on a project and need to keep track of my contacts at each office. I first need to put all of the offices I contact into one large group. Each office is different. Some have one contact. [...]

Answer Question   |  December 12, 2005  9:12 AM
Automated, Call Centers, Career development, Certifications, CRM, Database, DB2, Development, E-business, Exchange, Exchange security, Oracle, Partner facing, Project management, Software, Software testing, Tech support, Training

Encrypted files on External HD, host machine formatted but recoverable
Here is the lowdown, we have an external HD, and we backed up all the data needed too it. What i wasnt told was that the backup was being encrypted as it was being saved to the HD. So the pc was given to me to format and reinstall windows on. I did and now [...]

Answer Question   |  January 11, 2006  4:54 PM
Application security, Biometrics, Database, Digital certificates, Encryption, Exchange, Identity & Access Management, Instant Messaging, provisioning, Secure Coding, Security, Security tokens, Single sign-on

Procedure Compilation
Hi Friends, Have a small glitch and hence hope you will spare me a moment. Have a small procedure and it is not compiling. Could you just have a look and let me know why ? Thank You, Friend33 PROCEDURE Create or replace procedure proc_name IS Pwd varchar2(8); user varchar2(8); v_email varchar2(40); BEGIN Create or [...]

Answer Question   |  December 7, 2005  4:58 AM
Database, DB2, Oracle

Performance Optimisations
I need to optimize the DB for my Company web site expecially I need to be sure that I have all the right views. There is tool that analize the SQL request and propose to create the needed views? Thanks.

Answer Question   |  December 4, 2005  4:27 PM
MySQL

iSeries any beyond
I’ll start by introducing myself and my background and then hopefully explain what information i’m looking for. I’m a COBOL developer for an insurance company based here in Ireland. I’d like to think of myself as been proficient at programming and at navigating my way around the AS/400. I have experience in other non-AS/400 languages, [...]

Answer Question   |  December 3, 2005  6:31 AM
AS/400, Data analysis, Database, DB2, Development, Oracle

How to solve lock problem in Oracle 9i on Linux
Hi DBAs I have foundPersistent Lock in my database Suggest me how to solve this error.

Answer Question   |  December 2, 2005  6:57 AM
Database, DB2, Oracle

SET verb in COBOL
Hi The SET verb in COBOL set the value of a particular variable to a specified value. Now say I decalred a variable as 05 WS-SWITCH PIC X(01). 88 VALID-VALUES VALUE ‘A’, ‘B’, ‘C’. 88 NOT-VALID-VALUES VALUE ‘D’, ‘E’, ‘F’. If I want to set the value of WS-SWITCH as ‘A’, we can do as [...]

Answer Question   |  December 3, 2005  3:36 AM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE

Cannot connect to Database Oracle Error -1033.
Hello, I have a Problem with my HP B132L-Workstation, running HP-UX 10.20 and Oracle 7.x. An application, which is based on the Oracle database won’t start any more with the Error Message: Cannot connect to Database Oracle Error -1033. My first guess was, that the Harddisk is defective, or the Database is somehow corrupt. Against [...]

Answer Question   |  December 1, 2005  3:15 PM
Database, DB2, Hardware, Oracle, Software, Tech support

Data Integration
We are in the beginning stages of integrating data between a PC based inventory system and the iSeries. Specifically we will be downloading and uploading data between the two systems automatically. We have had success using ODBC. We also need to be able to call an RPG program from the PC based system. I’m sure [...]

Answer Question   |  November 30, 2005  2:39 PM
DB2 Universal Database, SQL Server

Remore RS232 Control
Good Day All I wondered if anyone knows how to remotely access and control RS23 devices. I will give you my example. I have a PC which is attached to 2 RS232 devices. I would like to have some form of control of the devices attached to the PC from a remote location, like a [...]

Answer Question   |  December 7, 2005  6:25 AM
Cabling, Database, DataCenter, DB2, Desktops, Development, DHCP, DNS, Exchange, Hardware, Management, Microsoft Office, Microsoft Windows, Mobile, Networking, Networking services, Oracle, OS, Project management, Security, Servers, Software, SQL, SQL Server, Tech support, Wireless

What is correct syntax for SQL for Maxrecords in OS400/DB2?
What is correct syntax for SQL for Maxrecords in OS400/DB2? We have a process automatically generating SQL code. However, our iSeries doesn’t recognise the code it generates for maxrecords. Here are the examples of what I mean. The DB2 database seems happy with SELECT I1PHON,I1ACC,I1ACC1, FROM “TRNGDATA1″.”OICRT1″ FETCH FIRST 1 ROWS ONLY However the standard [...]

Answer Question   |  November 20, 2009  12:10 PM
AS/400, DB2 Universal Database, SQL Server

VPn solution required for remote IP telephony
We would like to have remote ip telephony connectivity for our office so that it will be helpful for our remote users and our Royal customers to have ip soft phone which will be connected to our network through VPN tunnel to our IP PABX and dial out locally. We are having ADSL modem connectivity [...]

Answer Question   |  November 27, 2005  11:40 AM
Application security, Availability, Cabling, Database, Encryption, Exchange, Firewalls, Forensics, Hardware, Hubs, Incident response, Instant Messaging, Intrusion management, Network security, Networking, Nortel, Routers, Secure Coding, Security, Switches, VoIP, VPN, Wireless

Regarding Oracle connectivity issues
I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the OLE DB [...]

Answer Question   |  November 29, 2005  7:51 PM
Database, DB2, Oracle, SQL, Windows

DB2 Joins
Can someone explain the order this join specification will be performed in? RSINDIP LEFT OUTER JOIN RSINDPP ON RSINDIP.INICID=RSINDPP.IPICID LEFT OUTER JOIN MKEMLAP ON RSINDIP.INCID=MKEMLAP.ELEMIC LEFT OUTER JOIN MKIPRMP ON RSINDIP.INICID=MKIPRMP.IKICID LEFT OUTER JOIN RSTHSTP ON RSINDIP.INICID=RSTHSTP.TVICID Thanks,

Answer Question   |  November 23, 2005  5:22 PM
DB2 Universal Database