• Access path and open data path in DB2/400

    When will an access path be created, and when will an open data path be created?

    TNKR130 pointsBadges:
  • Migrate application from UNISYS to AS/400

    How can we migrate an application currently running on the UNISYS platform to AS/400 platform. A major portion of the source application is in COBOL and uses the DMS-II database. This has been migrated to COBOL and RPG on AS/400 using the DB2/400 database.

    126170 pointsBadges:
  • IBM Linked server will not do inserts

    I've spent close to 2 days looking for an answer and only got a headache. We have our IBM DB2 linked server defined as IBM DB2 UDB for iSeries OLE DB Provider. We can run select, update and deletes we just cannot do an insert. Here are our sample statements. SELECT * FROM OPENQUERY(OUR_DB2,'SELECT...

    ToddN200089,115 pointsBadges:
  • File in external datastructure

    Will level check occur on program when you changed the file mentioned in external data structure?

    Kvrs8070 pointsBadges:
  • Is it possible to increase the length of an existing data area

    Dear All! Is it possible to increase the length of an existing data area, without disturbing the values in it? For instance, I have a data area with initial length of 256 with some values already in it. Now that some more fields need to be added to the program (due to enhancement) which writes into...

    svankipu625 pointsBadges:
  • AS/400 / CF DESC

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

    AFNAN1198910 pointsBadges:
  • 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

    Sureyz2,825 pointsBadges:
  • 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 ?  

    anupsshelke420 pointsBadges:
  • 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...

    aderene185 pointsBadges:
  • 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      ...

    iiiiiiiiiiiii335 pointsBadges:
  • 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 ?

    tcuccaro40 pointsBadges:
  • 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...

    ARTZONE25 pointsBadges:
  • 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)

    NicyChn140 pointsBadges:
  • Track Database SSL connections

    Hello, We have VeriSign certificates installed to allow for SSL connectivity to Telnet, the Database...etc. Problem is that I need to be able to track who's using SSL to connect to the database on port 9471 and output it to a file. Any ideas on how to go about finding this information. I cannot...

    Bggas400160 pointsBadges:
  • As 400 database linking to the website

    Hi I want to link the account enquiry option on the AS 400 to the company website so that users can make account enquiries on the site. my question is how can I link the two?

    Dumieprince5 pointsBadges:
  • Data Structure in CL

    Hi,     Upto my knowledge we cant use data structure in cl... Is it Possible? If it Possible then How?

    22917560 pointsBadges:
  • 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...

    TrentTheTrainer5 pointsBadges:
  • Restoring journal receivers

    A search400 reader wrote in with this question: A situation has come up in our shop where we need to restore the QAUDJRN receivers from the production box to the test box (due to storage limitations and the large size and number of the receivers to be restored). We ran the following command: RSTOBJ...

    Leah Rosin600 pointsBadges:
  • DBF in AS/400 – last record written

    Hi , There is  file which has 6 fields and the first four as its key. Is there any way to figure out which is the last record written into it.   Thanks

    Atti123135 pointsBadges:
  • 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?

    TomLiotta125,585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following