• How to increase the no. of records accomodated in a sequence no. field of 6-digit (Numeric Field) length?

    Dear all! My situation is..... I have a field (Sequence Number) which is a numeric-field (Len 6,0). Now the records this field can accommodate is limited/restricted to a maximum of 999999. This application has been running for years together now. Therefore the demand to accommodate maximum no. of...

    svankipu560 pointsBadges:
  • Move cursor to screen position in AS/400 macro

    Is it possible to move cursor to specific screen position in an AS/400 macro file (not VB)

    Willable15 pointsBadges:
  • iSeries DB2 – Have Physical File need to create Logical File to access Member

    I know very little about the iSeries (I can spell it is all). I am working with an ODBC connection to get to DB2 data on the iSeries.  Everything is going extremely well other than 2 files that I need to access use members.  These are the only ones that do on the entire system.  I was told that...

    mgrady15 pointsBadges:
  • AS/400 via Access, update query

    Hi all, My DB is on AS/400 and I use Microsoft 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? Thanks in...

    Antser5 pointsBadges:
  • Install iSeries on none IBM server

    Can we install iSeries or create iSeries partition on none IBM server?

    abar1425 pointsBadges:
  • Upgrade AS/400 SSL from 128-bit to 256-bit

    Kindly provide me assistance on how to perform the upgrading of AS/400 SSL Certification from 128-bit to 256-bit. Currently I'm connecting to AS/400 via client access running on SSL 128-bit.

    Puva12345 pointsBadges:
  • RUNSQLSTM and Excel

    Can an Excel spreadsheet be created with the runsqlstm?

    lewman5 pointsBadges:
  • Query

    Hi Team, I have scenario with me. For that I need to create a query. The scenario is as follows: When My Location And Department is equal in the file I want to Multiply Quantity Column with Cost Column and Add it. Loc Dept Quantity Cost 1 10 10 2 1 10 10 3 1 10 11 5 2 10 10 7 For above example in...

    ankit2002770 pointsBadges:
  • ODBC Library list

    Dear users, If we are using Excel to get External data from iSeries, can we add a library temporary to a predefined Data source such as we can do during File transfer Properties?

    chalenger455 pointsBadges:
  • Locked Records

    Is there an easy way to trap a Record Lock in RPGLE

    Doc135 pointsBadges:
  • RPGLE Record Lock Data

    I have a program that get a Record Lock. I have captured the *status, however, I need the Program & User that initially read the record first.

    Doc135 pointsBadges:
  • AS400 subsystem listings

    Not too sure specifically how subsystems are listed in the AS/400. I know there are startup programs and subsystems need to be 'pointed' there in order to autostart? Questions is: Is there a way to list the current autostarted programs and how I can remove them. If there isn't a way to list what is...

    Gramicci65 pointsBadges:
  • AS/400 opcodes

    What is the difference between LOOKUP and XFOOT opcodes? Where can we use these opcodes?

    Icc10 pointsBadges:
  • iDB2 connection String permenant solution

    I have a DB2 connection string to our i-Series that works. "DataSource=10.10.10.10;userid=LIVEXML;password=LIVE1;DefaultCollection=DATALIB031;" We have been developing a lot of apps and web services that use this type of connection. My problem is when our i-Series software is upgraded (about every...

    ToddN20009,915 pointsBadges:
  • How do I check members list for a specific user group in iSeries (AS/400)

    What is the command to request system to list out member of a particular group profile with the assumption that my user ID is just a normal user ID (without SECADM function). Please help.

    Grpprfmbr20 pointsBadges:
  • French accent

    Hi everyone, SAP put a flat file in an AS/400 folder. The format is .csv (with UTF8 specification). When I use the command FTP in AS/400 to get it (User,passw,cd,get.....), every french accent is garbage. I changed the CCSD file, but nothing. I really need help.

    hewitt10 pointsBadges:
  • Convert C Prototypes to RPG

    I need to interface our payroll progam to Vertex Q Series payroll tax software. Vertex is written in C and our payroll programs are in RPGLE. Does anyone know what the RPG prototype to this function would be? PREFIX tVprtConn POSTFIX VprtOpenPRT (char *pDataSource, char *pServerName, char *pUserID,...

    moolar20 pointsBadges:
  • Error in Data fetching

    Hi all, My requirement is i have a CL program which is calling RPG Program R1, which writes data to an Output file PF1. Now i need to Change the RPG program R1 in such way that it should write data to PF0 instead of PF1, and i need to create another RPG program R2 which reads data from PF0 and...

    Sai4AS4001,420 pointsBadges:
  • WRKSPLF options

    Is it possible to add an option to the WRKSPLF screen? Options 1-9 are used but could I add an option 0?

    filuphaze475 pointsBadges:
  • How to Create a new OPTION in the Work With Spool Files screen

    We have a command we want to employ for spooled files, that will utilize the Job Name/Number/User of the spool file, to execute a task. How can I make a NEW Option, so User's can simply put the option (like a "P") on a spool file, to execute the task?

    Grant5 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