AS/400 / CF DESC
Hello I am trying find a way to change the Customer Friendly Description in the SKU (SKN) DESC. 

Answer Question   |  March 13, 2013  9:21 AM
AS/400, AS/400 database

Connection String for AS/400
Hi all. Here I’m using iSeries Server. I just want to connect VB.NET with AS/400 database. Simply I want to retrieve some data from a PF on VB.NET. Anybody can you tell me what is the connection string should be used? If you have any simple sample code in VB.NET please post here… Surey

Answer Question   |  February 14, 2013  8:29 AM
AS/400, AS/400 database, VB .NET

database
if i have one pf (pf009) and one logical file (lf009) on pf009. how we can add one more field after compalisation of logical file ?  

Answer Question   |  June 8, 2012  5:17 PM
AS/400 database

AS/400 Query
I use Query400 to output negative temperatures to a database file. The output file is currently created by the query at run time. The data is output as packed but I need the sign separate. I can’t see how to convert the temperature to a character string either as the sign is ignored. Any other [...]

Answer Question   |  May 8, 2012  11:55 AM
AS/400, AS/400 database, AS/400 Query

How to classify AS/400
I am in the process of writing a plan to integrate some software  into our AS-400 system. When referring to this system, is there a category I can classify it as? For example…”The purpose of this proposal is to help defer the costs of integrating our new software with our ____________________.” I am not sure if my audience would [...]

Answer Question   |  October 11, 2011  1:54 PM
AS/400, AS/400 administration, AS/400 commands, AS/400 database

AS/400 transactions
If iam in the mid of transaction of some sqlcodes if suddenly server is shut downed due to power down or sumthing what will happen. (Transaction will be committed or Transaction will be rollbacked or status ‘COMMIT PENDING’, or transaction wil stop)

Answer Question   |  March 31, 2012  12:51 PM
AS/400 administration, AS/400 Data File, AS/400 database

AS400 comparing large database files, cobol code taking too long
Hi, I need to compare 2 large database files on the AS400, they have 20 million + records each. They are both keyed uniquely, exact same file layout. I need to identify inserted, updated and deleted records. I tried using cobol program reading first file with the unique logical, and matching with the second file [...]

Answer Question   |  March 31, 2012  5:30 PM
AS/400, AS/400 database, AS/400 Database File, COBOL

How do you use multiple member files in Crystal Reports?
i have to retreive data from as400 iseires files that have multiple members and most do not have a logical for that member without creating a new logical is there anyway to tell crystal reports to use a certain member ?

Answer Question   |  March 31, 2012  3:16 PM
AS/400 database, Crystal Reports, iSeries, iSeries AS/400

AS400 %trim
Hi I have a question,i wanted to right trim the field to remove the spaces. but when iam doing it ,iam unable to do it. i did like this eval fld1 = %trimr(fld1). so please suggest whether this is correct or not?      #TBLDGH       KLIST                                                                      KFLD                    DGHCOD                          *   *LOVAL         SETLL     TBLDGH                                                           READ      TBLDGH                                        [...]

Answer Question   |  March 31, 2012  12:37 PM
AS/400, AS/400 database, AS400 Data Definitions

Initiating a job when an as/400 database is updated
How can a job be initiated whenever a as/400 database is updated. We currently have a job that runs every hour even when there is no data to process. When there is data, it is processed then the database is cleared. Is there a way to trigger the job to run only whenever the database is populated?  

Answer Question   |  March 31, 2012  9:56 PM
AS/400 database, AS/400 jobs, iSeries, RPGLE

AS/400 Authorization Lists
I created a AUTL with only Read access to certain files.  When my user ran an SQL statement against one of the files in the AUTL that he is a member of it said that he did not have authority to the file.  Why would this not work?

Answer Question   |  June 20, 2011  4:47 PM
AS/400, AS/400 Authorization List, AS/400 database, AUTL

Export AS/400 database to new website
how would we go about exporting our as400 product database of 2,000 items (without images – only image name or link) to our new website?  we would likely be using a Joomla content management system (CMS) website but would use standard HTML if we had to.

Answer Question   |  May 18, 2011  1:51 PM
AS/400 administration, AS/400 database, AS/400 database administration

Transfer Data from AS400 to Excel using Reflection
I need help learning how to create a file transfer from the AS400 to an Excel spreadsheet using Reflection. I am not a “techie”; what I’ve learned has come from countless hours of using the “help” button and reading technical blogs. I knew how to create DTF requests when our company was using Client Access [...]

Answer Question   |  May 20, 2011  5:08 AM
AS/400, AS/400 data transfer, AS/400 database, IBM Reflections, Reflection Data Transfer

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

sflcode & COBOL/400 code
i have a database file name emp         file name=Emp R emprec    Eno           10p    Ename      10a    Esal          10p k Eno and subfile name is empsfl  sflrec Contain fields   SEno        10p   SEname   10a   SEsal       10p sflctl contain indicators [...]

Answer Question   |  March 4, 2011  2:01 PM
AS/400, AS/400 database, COBOL, COBOL/400

AS/400 via Access, update query
Hi all my db is on as/400 and i use ms access to run queries. however, whenever i try to run an update query i receive the following error message: “[IBM][ISeries Access ODBC Driver][DB2 UDB]SQL7008 – table in library not valid for operation. (#-7008)” any idea what is missing? thanx in advance

Answer Question   |  February 17, 2011  12:18 PM
Access query, AS/400, AS/400 database, AS/400 Query

AS400 DB2
How do I access the data in a journal receiver?

Answer Question   |  February 9, 2011  9:17 PM
AS/400, AS/400 database, DB2, iSeries, Journal Receivers

Data Structure in CL
Hi,     Upto my knowledge we cant use data structure in cl… Is it Possible? If it Possible then How?

Answer Question   |  October 31, 2011  7:29 AM
AS/400 database, CL, CL programming, Data structure

AS/400 field modification impact on other related objects
I have a file field which we are planning to expand. The same field name is used in some of the files, DSPF’s and PRTF’s. If a program A has this impacted file declared, how can I find the other objects which are impacted due to this modification?

Answer Question   |  January 6, 2011  4:15 AM
AS/400 database, AS/400 Fields, DSPF, PRTF

Database field in CLP
hi, I am reading a database file line by line and want to display the records in QSYSOPR. i am using CHGVAR   VAR(&A)   VALUR(B)         where &A = variable in CL, and                  B = field from database file SNDPGMMSG &A MSGQ(QSYSOPR) But the problem is i am not getting value of B rather i [...]

Answer Question   |  December 22, 2010  11:18 AM
AS/400, AS/400 database, AS/400 Database File, AS400 CLP, QSYSOPR