small doubt
Hi, I have a small doubt in AS400 programming. This is regarding receiving journal entries. I am using ILE C to write the exit program. I am using RJNE0200 format on the RCVJRNE command. I am getting the entries in the exit program. But I have a few questions:- in the RJNE0200 format, there are...
View Answer
| Jul 18 2005 7:26 AM GMT
| asked by
pprasad123
DB2, UDB for iSeries/i5, OS/400
Changing the statement heap parameter on iSeries
Hi,I would like to know how to change the statement heap parameter DB2 (stmtheap) on the AS/400. I tried the command GET DATABASE CONFIGURATION FOR database-alias (giving alias name as the AS/400 server name) but it returns the error "SQL0901N The SQL statement failed because of a non-severe...
View Answer
| Jun 8 2005 6:10 AM GMT
| asked by
sbkhole
DataCenter, Data center operations, Physical security
Calling External Procedure from Java Web based Application
Below given is a procedure to access a CL Program in iSeries from a Java web based program.create procedure libxxx/proc_name LANGUAGE CL FENCED EXTERNAL NAME 'libxxx/clprogram' PARAMETER STYLE GENERALThe external CL program has other calls...
View Answer
| May 26 2005 5:09 PM GMT
| asked by
TOKNOWIT
IBM, IBM WebSphere, J2EE
Inserting data into a vargraphic data type field
How to insert data into a vargraphic data type field. I have done the following CREATE TABLE TEST_TABLE (FLD1 VARGRAPHIC(20))This is done succesfullyINSERT INTO TEST_TABLE VALUES('TEST')This gives a SQL error Please let me know how I can acheive it.
View Answer
| Apr 28 2005 9:44 AM GMT
| asked by
sbkhole
DataCenter, Data center operations, IT architecture
MS Query - Client Access DSN error
I'm receiving SQL0901 error when I establish a connection through MS Query to the 400. The job log failure is QQQISVSU (level 40) stating "Attributes of value number 2 in field HVR0002 not valid" I've disabled query wizard in hopes that the SQL request would not be made and it gives the same...
View Answer
| Feb 21 2005 10:35 AM GMT
| asked by
jsimmons
Microsoft Office, UDB for iSeries/i5
SQL joining tables across multiple AS/400’s
I would like to execute the following query.The problem is that the Table INVMST is on a different AS/400 than table CHURDLES.INSERT INTO IDEASLNT/SHURDLES SELECT I.IDEPT, I.ISDEPT, I.ICLAS, I.iSCLAS, I.ISTYL#,I.ASNUM, ...
View Answer
| Jan 18 2005 12:19 AM GMT
| asked by
apothen
AS/400, UDB for iSeries/i5, OS/400
WALLDATA RUMBA File Transfer Function
After upgrading from NT to XP or Win2000, the File Transfer function no longer works. Arpeggio is fine but the File Transfer application error is:[Wall Data][Rumba Data Access]No data source specified; dialog prohibited. SQLDriverConnect.... Maybe there are registry entries missing?...
View Answer
| Dec 7 2004 9:31 AM GMT
| asked by
RPGGuru
Data center operations, Tech support, Third-party services
Moving spool files from one AS400 to another
I'm having a problem retaining the spool file attributes when I tranfer spool files from one ISeries to another. I can use the SNDTCPSPLF and it retains most of the attributes but does not retain the user and date/time attributes of the original spool file. Any suggestions??
View Answer
| Nov 12 2004 5:47 AM GMT
| asked by
pperry
AS/400, Hardware, DB2
DB2/400 SQL Sub Query Performance?
Here is the problem. Table INVEHH is a (Events header table) with about 500 records and INVEHD (Event Details) with about 22 million records. These tables are on a DB2/400 database.1) Original Query that takes forever: select EVENT, INUMBR, ISTORE, EVHYY, EVHMM, EVHDD from INVEHD ...
View Answer
| Oct 20 2004 8:40 AM GMT
| asked by
apothen
Database Management Systems, DB2, Data warehousing/Business intelligence
SQL View over a table with members
Hi all, I have an as/400 table(fileA) with several members, I need to create view that joins this to several other tables but but I need to only target one member in fileA. The other tables are all single member tables. I tried to create an alias over the table and then create the view but that is...
View Answer
| Sep 30 2004 9:42 AM GMT
| asked by
Lpgast
DB2, UDB for iSeries/i5
