• DB2 SQL

    Hello Sir,             I am creating a table through SQL in AS/400. CREATE TABLE ANUP41/EMPL4 (NAME CHARACTER ( 10) NOT NULL, ADDRESS CHARACTER ( 25) NOT NULL, PROFILE CHARACTER ( 10) NOT NULL, UNIQUE (NAME))                                                      ...

    anupsshelke420 pointsBadges:
  • How to show data decimal error message to user through coding?

    How to show data decimal error msg to user through coding?

    RamvishakRamesh2,505 pointsBadges:
  • Display Screen Design

    Hello, I want to design a Display screen...please provide me where can i get the information . please post some links or info.  I am new to AS400 Thanks, S

    SOW110 pointsBadges:
  • CPYTOIMPF .txt file shows garbage on IFS when viewing on windows

    CPYTOIMPF .txt file shows garbage on IFS when viewing on windows but when using wrklnk it looks fine, please help.Below is the query I am using CPYTOIMPF FROMFILE(BIN815PA) TOSTMF(&PATHDAT) + MBROPT(*ADD) FROMCCSID(*FILE) + STMFCODPAG(285) RCDDLM(*CRLF) + STRDLM(*NONE) FLDDLM(*TAB) CPYTOIMPF...

    Satvik35 pointsBadges:
  • AS/400 Profile getting disabled by MS Access

    We continue to have an issue where an AS/400 profile gets disabled by MS Access. This only happens sporadically (i.e not with the daily or hourly run of the scheduled tasks/jobs on the windows server). We are using ODBC linked tables to pull data from a couple of AS/400's in to MS Access. The other...

    Kdh05045 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:
  • Upgrade from V5R4M0 to V6R1

    Hi, We have 9406-520 machine with V5R4M0 OS. We are planning to update with V6R1 os by this month end. I want to know, is there any CUM PTF required for updating OS or I can Update directly.Please suggest. Thanks, GK

    venkatktata285 pointsBadges:
  • CL/QMQRY

    i hav code   STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT)   In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it...

    Sanashakeel15 pointsBadges:
  • CL Programming

    PGM                    DCL VAR(&TIME) TYPE(*CHAR) LEN(6)                    DCL VAR(&DATE) TYPE(*CHAR) LEN(6)                    DCL VAR(&YEAR) TYPE(*CHAR) LEN(2)                    RTVSYSVAL SYSVAL(QTIME) RTNVAR(&TIME)                    RTVSYSVAL...

    anupsshelke420 pointsBadges:
  • As400

    i need to convert folling rpgle code into rpg EVAL      CMDKEY = %TRIMR(CMDKEY) + ' ' + F6COM 

    Nikrajpapa230 pointsBadges:
  • Printer Overlays

    What is the simplest way to create an overlay for a printer file? I'd prefer to go generic, rather than buy a package.

    OldScott10 pointsBadges:
  • CPF3309 error message

    While executing CPYSPLF command I get the error CPF3309 with the error description , " No files named &1 is sctive",Please let me know your thoughts and advice solution for the same

    assa150 pointsBadges:
  • AS400 TELNET

    Hi, whilst having problems with connectivity to AS400 sessions, was advised to restart the TELNET service. How do i do that, will a simple ENDHOSTTCP and STRHOSTSVR do? or do we have any specific procedure that need to be followed to? Thanks in advance

    harisudhan211,005 pointsBadges:
  • Recompile CL program

    Hi, We added few new fields to an exising Physical file. When I check for the dependents for the changed Physical file in ALDON it shows 250 dependent objects. Do I need to recompile all 250 objects? Thanks, Elan

    elan0030 pointsBadges:
  • How do you code footers in DDS Print File?

    I need to print a footer on every page of a report. Thought it would be simple like headers. If anyone has the answer let me know. Thx.

    Kdbwheels180 pointsBadges:
  • iSeries number of Web users

    How can I find out who is logged into the system via an applications web interface?  i.e. Lawson, Jgo, etc.

    NickHutcheson11,380 pointsBadges:
  • COBOL400

    I get the following message MCH3601 (pointer not set for loacation referenced) when calling a Cobol program from another Cobol program, passing 4 paramters.However this abend happens on the second call to this program as the first call was sucessful.Can anyone help me. It fails after open...

    Rr22100 pointsBadges:
  • Vista and Office 2007

    We have a customer upgrading their PCs with Vista and Office 2007. The host is an 820 at V5R3. iSeries access fix pack is SI28055. Does anyone have this mix and do you have issues to report? Thank you.

    maryann465 pointsBadges:
  • CPYTOIMPF .txt file shows garbage when viewing on windows

    CPYTOIMPF .txt file shows garbage on IFS when viewing on windows but when using wrklnk it looks fine, please help.  below is cmd than used.  /* copy the file to stream file and put delimiter */       CPYTOIMPF  FROMFILE(&FILENAM) TOSTMF(&STRFILE) +        ...

    M0015 pointsBadges:
  • Security and QSECOFR number of sign-ons

    For security purposes, the number of sign-on attempts can be *NOMAX or as few as one. I configured for 3 maximum sign-ons. Does anyone know if the OS/security sums the total number of sign-on attempts from the device only before it disables the device, or does the OS not count total from the...

    Gmil494365 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following