• Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!

    We're always looking for great resources to share with the community, so here's your chance to share what's in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you'll never forget. Don't have a...

    MelanieYarbrough6,345 pointsBadges:
  • How to control AS/400 user profile from updating database?

    There are several user profiles created in our AS/400 server. I need to control some of specific set of user profiles from updating database. Is there any option to achieve this request? Example: Consider Profile1 and Profile2 created in AS/400 server. Profile1 should not have access to update the...

    ganeshpavi75 pointsBadges:
  • iSeries Report printing to network printer – font too small

    We have an AS/400 print file which is defined with: 10 CPI, 6 Lines per Inch, Width of 132, Length 66, Font Identifier is *CPI. We were using an AS400 print emulation session to print the report but want to get rid of this and use a device/outq on the as400. The report prints to a networked HP4050...

    Lehanb30 pointsBadges:
  • Turn on job logging on iSeries

    I have been asked to turn on job logging so that it produces spool files. I have verified that the user's job description has logging turned on but this is not producing spool files of the logs. Any help would be greatly appreciated!

    Camgin55 pointsBadges:
  • Answering MSGW with no manual intervention

    I need to be able to have MSGW answered with no manual intervention. I would like to be able to maybe just add to the command when submitting the program. I have several MSGW that are always answered with the same thing and have no access to source code. Also have very limited AS/400 experience.

    mapratt8235 pointsBadges:
  • AS400 Sign on

    When you take "Run the same" to open a new session you have to retpe the user id twice on in a window and then on the green screen. Does anyone know of a way to bypass one of the signons? Thanks

    JAC260 pointsBadges:
  • Data structure with array AS/400

    Sorry, I do not know how to explain this. I was expecting this can be work but it can't. It seems like will getting decimal data error. Can someone help on this? Field of FLD0 to FLD9 is from a PF which is 15,2. DS FLD          DIM(10) LIKE(FLD0) FLD0 FLD1 FLD2 FLD3 FLD4 FLD5 FLD6 FLD7 FLD8...

    yeepiyaya220 pointsBadges:
  • QPort message 635: Error while setting workbook to visible mode

    I know it's a stretch to ask about a 3rd party software message, but I'll ask anyway. I have a user who got message 635 while testing a QPort query. Additional text said "error while setting workbook to visible mode. Of course, I can't replicate the issue. Any suggestions?

    aceofdelts2,330 pointsBadges:
  • How to extract specific data in AS/400

    Hi there, I want to extract data which has last two digits as 00 (like in 10,000 and 10,001. I need to get only the records of 10,000) by using WRKQRY.

    patnam80 pointsBadges:
  • iSeries access em5250 v7r1

    Most are normal, Very few device occurs. Em5250 disconnect not regular. DSPLOG as follow: CPF4533  70  INFO  Error on device xxxxxx.  Device response code is 6155. 6155-No response from the device in  configured device wait time.

    lance2221357255 pointsBadges:
  • AS/400: Create a program that is invoked on using the command CHGPWD

    Hi, I am new to AS/400 and I would like to create a program that is invoked on using the command CHGPWD. How can I do that?

    Pranav0712110 pointsBadges:
  • AS/400 field won’t display

    A field with no dependent indicators is not displaying on the screen. It is being populated in the program but there is no display of it. This is not an empty field, it is litterally not going on the screen (no cursor position). What could cause this?

    DCokely5 pointsBadges:
  • Transfer data from iSeries RPG to Excel

    How can I transfer data from iSeries RPG to Microsoft Excel?

    Rmw10 pointsBadges:
  • ZPL Code for RFID TID in Barcode

    Hello, I'll start with what I have. I have: Labels: 4x2 RFID labels Printer: R110Xi4 (300dpi) and a scanner that ONLY reads these types of barcodes: Code 128, EAN-8, EAN-13, GS1 DataBar Expanded, GS1 128, GS1 DataBar Coupon, UPCA, Interleaved 2 of 5, UPC Coupon Code, PDF-417, and QR Codes. Here is...

    adrianh7145 pointsBadges:
  • AS/400 file to Excel with Headers and Footers

    I need to attach an Excel s/sheet to an email. I currently do that via the CPYTOIMPF as a CSV file but this doesnt give give me the true Excel Header row, which is a requirement. Is there any easy way to do this?

    NJFred35 pointsBadges:
  • How to validate data in RPG

    How to validate data (if it is numeric or character or both) in RPG? I have customer file(cus1) and field length of CID is 05. I want to display numeric data only. I don't know how to use indicators, please correct the below code. .............. CID  .  CNAME .............. 1201    chow...

    chowas400620 pointsBadges:
  • Java 7.0 install onto iSeries

    I have followed instructions from IBM and downloaded both the 32-bit and 64-bit versions of Java 7.0 but have not been able to find out how to actually install these .ISO files. I have them loaded into an image catalog and have attempted to install via the GO LICPGM, option 11 but to no avail.  I...

    Camgin55 pointsBadges:
  • Execute SQL SELECT via RUNSQLSTM error

    Trying to execute SQL-statement "SELECT * FROM mylib/myfile" give errormsg SQL9010. Some say that SELECT is not supported with RUNSQLSTM, but IBM command parameter text indicates otherwise. Is SELECT supported and what am I doing wrong?

    DanTheDane2,555 pointsBadges:
  • SQL Connect to remote system, run retrieved data on local system problem

    I need some help with the syntax required to build the SQL commands (embedded into an RPGLE program) that will do the following: Connect to a remote system (using a userID & password passed into the program as parameters). Dynamically build ALTER commands based on data SELECTed from a table on...

    mikechance8126325 pointsBadges:
  • Special characters in COBOL

    Hi everyone, I have a program in cobol400, which is using SQL to remove the special characters with "select replace( "description", "@" , " "). Is there anyway I can remove characters like , ' , and " with the program? Thanks and regards, Vinod.

    MyDataTransfer20 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