• Converting date values in AS/400 database

    How do I convert a date value 20/09/1231 for 31st Dec 2009 in the database to be able to use a query of checking this date against current(date)?

    Bonbon7830 pointsBadges:
  • iSeries SQL UDF gets CPF426A

    I created a SQL UDF using the iNav wizard.  It created the service program for me yet when I try to use the function I get CPF426A "User-defined function &5 cannot be invoked." with a reason 2 (Either the service program is not found or the program entry point &6 does not exist.)  It says the...

    RJonesPartrick25 pointsBadges:
  • Can a nested query be run in AS/400?

    There are multiple lines (sequenced) of my records in a table with the same Key. Example of the table Student No.     Name         Grade      1001              Michelle       Fail 1001              Michelle       Fail...

    Bonbon7830 pointsBadges:
  • How to restrict required libraries and through error message when tried to access. in as/400

    Remove production libraries from system value QUSRLIBL.  Having these libraries in the library list when a user signs on it effect gives them authority to the libraries.  Ssecurity enhancements have to be implemented to users who do not have specific authority to these libraries and should...

    Santoshreddyb15 pointsBadges:
  • ovrdbf in rpg

    hi guys.. i am getting a file name as a variable from CL program. based on some condition i want to write in differnt members of the file.since the file name is stored in a variable i cant able to declare it in f spec. so i created a duplicate object for that file and i declare it in f spec. Now i...

    Santhaseelan10 pointsBadges:
  • V5R4M5 SLIP upgrade problem

    Our VAR suggested that we apply the V5R4M5 upgrade. Durring the SLIP install I received a request for the next CD. We only received the oneCD "I_BASE_01". This caused the IPL to show error B6000414. Anybody know if there is supposed to be a CD #2 or what else is causing this problem

    Arawn5 pointsBadges:
  • embedded sql performance over large files

    We have many applications using embedded sql statements. We are discovering that as the files grow larger the performance diminshes significantly. We have tried using dbmon to ensure indices are not being built on the fly. There are either indices or logicals for all keyed access sequences. Any...

    Bbilgen0 pointsBadges:
  • Retriveing massage from submited job in CLP

    I have CLP and a cobol program. CL program calls the cobol program in Batch mode by doing SBMJOB. The cobol program processing 1000 records from a database file. If it founds errorneous record in the time of processing, then it stops processing with a system generated error massage and control go...

    Mithunpaul15 pointsBadges:
  • Email message sent is printing 2 pages

    I have written a process where a salesrep remotely orders a special item that we don't normally carry and it signals the buyer to order it.  When the item is ordered the system emails the salesrep. I use SNDDST with *LMSG with a short note stating the item has been ordered with item, vendor,...

    filuphaze475 pointsBadges:
  • InfoPrint Server Mapping question

    We are evaluating Info Print server and trying to use the mapping program to send emails. We are receiving error message PQT3611 Stream File not found for user. Has anyone experienced this issue?

    CandyH0 pointsBadges:
  • MIMIX – CPU utilization

    Hello All, We are using 2 i5 550 machines, one for Production and the other for Backup. MIMIX (Online replication software from Lakeview) is used to replicate data between the two machines. We have noticed that MIMIX is slowing down performance on the Production machine by almost 20%. We tried...

    ITLBADMN0 pointsBadges:
  • Necessity of a multi-member PF in COBOL

    How do we read a multimember PF in cobol ?How does it differ from a regular PF ?

    Supriyob2165 pointsBadges:
  • Meaning of USER MOD FLAG generated in RTVCLSRC

    The source generated from the RTVCLSRC command has some header comments which give some information about the CL program.  One comments has; "User mod flag  . . . . . . . . . . . . . :   *YES" .  I can't determine what this means or refers to.  Any ideas?              

    Unknowing120 pointsBadges:
  • printer problems we have a dell 5100cn but we can not print through our AS400

    we have a dell 5100cn but we can not print through our AS400 it stops the writer and gives error message every time can anyone help with this please

    Biomedtech5 pointsBadges:
  • Mapping a drive from QNTC

    I have to have a drive from a Windows server permanently mapped to my ISerie for batch FTP purposes. When I issued the command MKDIR QNTC/servername, it worked fine. The problem is that at IPL time, the link is broken, What's the best way to keep the connection with the Windows server? Should...

    Hmonat20 pointsBadges:
  • %diff and data structures

    I have dates that come into my program as cn yy mm dd. I put these pieces in a ISO data structure to do some calcs. I want to find how many months transpired between to dates using the %diff. Can I do this with the dates being in a data structure? My program is telling me my parameters are invalid....

    JLGARSEEYA0 pointsBadges:
  • Viewing the list of libraries in *SYSVAL

    Sudarshan wrote in with this question recently: "How can I see the list of libraries in *SYSVAL?" -- Deb Tart, associate editor

    DebraTart0 pointsBadges:
  • User Auditing/Journaling

    I'm new to security on the AS/400 (730). We need to have a record of what program a user calls through our ERP system or what objects are changed and who changed them. I've read some on journaling but not sure if that will work for what we need. Suggestions? Thanks Mark

    Hllwyrs0 pointsBadges:
  • Reading a File of unknown name, format, etc.

    I need advice on reading a data file in RPG where I will only know the file name, the file format, etc. at run time. I would like to use an API or something to read the file into a buffer; I could then use the QUSLFLD API to get field definitions and parse the fields as required. I am not...

    DaddyCOZ0 pointsBadges:
  • TAB in Physical File-2

    If I have a file which is created with no DDS (only Record length), how can I insert a tab in this field when I write record into the file using RPG?

    Kalice0 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