DB2/400
Why do I need logical file in DB2/400?

Answer Question   |  October 23, 2012  3:18 PM
AS/400 DB2, AS/400 logical file

update replace
I’m trying to update a particular text string in a long trxt eg 505400005004GBP23800280000 trying to replace the 10th char 0 with a 1 how can I do this please, thanks

Answer Question   |  June 26, 2012  5:06 PM
AS/400 DB2

pass array to clle
i created RPGLE,within that i defined compiled time array now i want to pass that array (at a time only one insex) to cllle but while i run this rpgle its give me run time error ..that  Error occurred while calling program or procedure *LIBL/practcl8 Message ID . . . . . . :   [...]

Answer Question   |  April 16, 2012  4:44 AM
AS/400 DB2, AS400 iseries, iSeries RPGLE

Logical file Error.
i try to create Multiple-format Logical File but i getting compile time error. i have two PF dds is as follow.. A          R RDEPTMST                A            DEPTNAME      15        A            DID   [...]

Answer Question   |  April 17, 2012  6:20 AM
AS/400 DB2, Logical File

Synon (Migration)
Dear Friends, We are in a plan of migrating system to some other technology like Java/.NET etc. Please find the details and questions below. Information about the current System: Synon (CA -2E) 8.5 Version Few modules the source is getting generated in COBOL and other in RPG Database we using DB2/400 Questions: What all should [...]

Answer Question   |  March 17, 2012  6:55 AM
AS/400 DB2, AS/400 Synon, RPG Data Fields

Using Dropbox and Radio button with DB2400
IS THAT POSSIBLE OF USING DROPBOX AND RADIO BUTTON IN DB2400?

Answer Question   |  March 31, 2012  9:31 AM
AS/400 DB2, DB2/400, Dropbox, Radio buttons

VSAM versus DB2 in CPU consumption
Is it possible estimate how much more CPU is consumed by DB2 commands in relation to VSAM KSDS when access a row, through an index scan, in a organized DB2 table against a record reading from an organized VSAM KSDS file through the primary index? How much is it in percentage? Thank you very much [...]

Answer Question   |  March 31, 2012  3:57 PM
AS/400 DB2, DB2, VSAM, z/OS CPU consumption

Connecting SAP to iSeries.
We are undergoing a project implementation in which we need to connect SAP to iSeries where SAP would be the target for fetching data from iSeries which is the source. Can anyone help me by providing the steps involved for Connecting SAP to iSeries. Also let me know if any addtional product is to be installed [...]

Answer Question   |  March 31, 2012  7:40 AM
AS/400 DB2, iSeries connectivity, SAP, SAP connectivity

Switch between two screens using CICS maps
how we can switch between two screens using maps in cics what will be the logic implemented in cobol programme?

Answer Question   |  March 31, 2012  2:16 AM
AS/400 DB2, CICS, CICS programs, COBOL

Not able to create procedures using STRSQL on V6R1
While creating a procedure in V6R1, [strong]Not authorized to CREATE PROCEDURE error (Message ID is SQL0552)[/strong] appears. In Additional Message Information cause of the error being — [strong]CREATE PROCEDURE or CREATE FUNCTION requires the *OBJOPR and *ADD authority to the catalog table SYSROUTINES in QSYS2[/strong]. However [strong]PUBLIC[/strong] has [strong]*CHANGE[/strong] Authority on [strong]QSYS2/SYSROUTINE[/strong] Object. Please note my [...]

Answer Question   |  March 31, 2012  7:22 AM
AS/400 DB2, AS/400 SQL, iSeries V6R1, STRSQL

Moving file from Linux to AS/400
how can i get a file from linux to my as400 use to do it with Client Assist but being told that does not exist in linux !

Answer Question   |  March 31, 2012  2:55 PM
AS/400 DB2, AS/400 to Linux OS, DB2/400, Linux, Linux file system

What are the steps needs to be followed while removing Key Fields from PF.
Hi, i have got a requirement to remove the Key Fields from the PF. Can anybody please suggest what are all the sequence of steps i shd follow to incorporate this changes to avoid any issues in Production after change. As per my knowledge below are the steps i am planning to follow, please confirm. [...]

Answer Question   |  March 31, 2012  5:43 AM
AS/400 DB2, AS400 physical file, DB2/400, Physical Files

Compare files in AS400
When i compare two files using CMPPFM command, i am getting message as request failed. This is because files were having huge volume of data. It was showing file exceeds 112498 records. Is there any other way to compare files of large volume of data in AS400. Please let me know.

Answer Question   |  June 7, 2011  6:42 PM
AS/400 command functions, AS/400 DB2, AS/400 File Sharing, CMPPFM

How to sort a db2 table column, containing date stored in char format.
i have a column which is not Y2K complaint, the values are stored in char format like ddmmyy ( i know its totally dumb), i need to sort based on ascending or descending order.  051193 -> 5 nov 1993  140308 -> 14 march 2008  141211 -> 14 december 2011   Now how do i sort this [...]

Answer Question   |  May 21, 2011  5:01 PM
AS/400 DB2, DB2, DB2 Table

DB2 Process automatically Shutdown
At  our site using IBM DB2 database there some problem with our DB2 Database services stop automatically .Error log  shown the  DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN. Thanks, Nilesh

Answer Question   |  May 13, 2011  8:51 AM
AS/400 database, AS/400 database administration, AS/400 DB2, DB2

Can we change length of CSV File
Hi guys, I have a CSV format file in my database which is used for Adhoc reporting. Now, I need to increase the legnth of that file. I am trying to increase using CHGPF command, But I wasnt able to do the same. Will any one of you suggest me the way for increasing the [...]

Answer Question   |  May 11, 2011  11:22 AM
AS/400, AS/400 DB2, CHGPF, CSV, CSV file format

Inserting and viewing of Chinese characters in DB2400
Dear All, We are trying to insert Chinese characters into an AS400 PF. We originally had the CCSID of the PF field as 13488, The job CCSID being 65535 HOWERVER when we are trying to input characters, it is taking as ????????? Later, we careated a new file – with CCSID 1200 and still the [...]

Answer Question   |  May 5, 2011  5:35 PM
AS/400 DB2, CCSID, DB2, DB2 administration

SQL equivalent of GRTOBJAUT using Authorization List
Using SQL script, how does one grant object authority to a table using an authorization list?   This fails because MyAutList is not a *USRPRF:  grant all on table mylib.mytable to MyAutList This works, but is not what I need: grant all on table mylib.mytable to Public 

Answer Question   |  May 2, 2011  5:03 PM
AS/400 DB2, Object authority, SQL Server, USRPRF

DB2 Tuning link or manual for AS400
Hi, In the company I work for we have a requeriment for tuning DB2 in as400. We still don’t know the server release, but I wanted to start searching for any documentation about that. I will appreciate any link or suggestions. Thank you. Regards.

Answer Question   |  April 15, 2011  3:14 PM
AS/400, AS/400 DB2, DB2

SQL Update Set: Higlight Customers without Invoices, Update and join Tables?
Hello, I am not sure how to do this with an SQL Update Set statemet: I have a table customers and I have related invoices. I would like to set one field to “not active” in the customer table that did not receive invoices since 2008. I can “Select” the corresponding records in the customer table [...]

Answer Question   |  March 28, 2011  2:03 PM
AS/400 DB2, DB2, SQL statement