Questions & Answers

  • Free IT Book: Two-for-one this week!

    We got into the holiday spirit for this week's free IT book giveaway. Answer one of the unanswered questions below and win two IT books from our coveted technology library. Another plus? You get to pick which two books you receive. So get to answering, because you have a week to throw your name...

    MelanieYarbrough6,345 pointsBadges:
  • How to track STRPCCMD errors

    Need some help with the command STRPCCMD. I am using this command in a CL program to display a .pdf document stored on the server. The name of the document is determined by the Cl program given the user and other parameter. All works well when the document is found in correct place. When the...

    tjgm88995 pointsBadges:
  • Free IT Book: Enterprise Web 2.0 Fundamentals

    For an introduction to next-generation web technologies, Enterprise Web 2.0 Fundamentals is a great place to start. Learn how to leverage cloud computing and user-generated content along with business and technical best practices. To win this, simply answer one of the questions listed below and...

    MelanieYarbrough6,345 pointsBadges:
  • Maximum number of files to declare in one RPGLE program

    How many files can we declare in one RPGLE program (maximum no. of file)?

    anupsshelke420 pointsBadges:
  • How do RPGLE program files get opened?

    When does a file defined in RPGLE program gets opened??

    C.naveen09140 pointsBadges:
  • How to condition the display option when RPG indicators are already used in RPGLE

    I've got a display file in RPGLE program... I want to display function key F19=View History based on certain condition. I planned to use indicator to switch on if the conditon meets and the option will be displayed. The problem here is all 01 to 99 indicators, KC,KE,KG,KJ,KQ,U2 are already used by...

    Nutangujar895 pointsBadges:
  • Difference between Structured Query and Query in AS/400?

    We used STRSQL- FOR START SQL(Structured Query Language) and STRQRY- FOR START QUERY. What is the difference between Structured Query and Query? (SQL and QRY)

    anupsshelke420 pointsBadges:
  • Use 200-character variable in AS/400 subfile

    Hi.. I have 200 character-length variable (for ex Address) as a field name. I want to use this in a subfile. Is it possible? How? By using sflfold option?

    Sureyz2,380 pointsBadges:
  • PageDown and PageUp functions in SFL subfile

    How to manage the PageDown and PageUp function in SFLSIZ=SFLPAG subfile..? If anybody have the sample codes for this please share it... Thanks.

    Sureyz2,380 pointsBadges:
  • FRCDTA and PUTOVR keywords

    What is the purpose of FRCDTA keyword? What is the purpose of PUTOVR keyword?

    kennedy2802110 pointsBadges:
  • How to access F15 on keyboard

    How do I access F15 on my keyboard when it only goes to F12?

    Pwsadmin5 pointsBadges:
  • OVRDBF in real time

    Hi, Can anybody tell me about OVRDBF in real time answers?

    Ben Rubenstein5,655 pointsBadges:
  • Confirm an AS/400 record without read and chain

    How do you know a record exists without doing read and chain?

    kennedy2802110 pointsBadges:
  • Error in AS/400 code?

    Fstdt if e disk Dnam s 10a Ddept s 3a C/exec sql C+ SELECT NAME, BRANCH INTO :nam, :dept FROM stdt WHERE STDID < 10 C+ C/end-exec C seton lr Hai all ..! I have this code .. But i'm not getting the output.. how can i get the result?

    Sureyz2,380 pointsBadges:
  • AS/400 SORTA command

    How to sort array in Descending order using SORTA Command?

    rajeshece1,215 pointsBadges:
  • OVRDBF does not convert all records

    I have 5 Different Files with 5 Members. I wanted to process all records in all members. I used OVRDBF FILE(FILE) TOFILE(FILE) MBR(*ALL command. It did not convert all records in all members. My AS400 version is not supporting EXTMBR(*ALL).

    rajeshece1,215 pointsBadges:
  • Set up DB2 Web Query dashboard

    I would like to be able to set up a dashboard on a particular managers desktop, and demonstrate the features of DB2 Web Query. Does anyone know of a good web site that I could go to, that would show me how to do this? Alternatively, are there any books on the market that someone would recommend?

    Piano520 pointsBadges:
  • Select fields in DB2 query without having them appear in ‘sort by’ window pane

    Hello Does anyone know how to select fields in the DB2 Query for report purposes, and yet not have them appear in the sort by window pane. Seem simple enough, but, when I have the field select tab highlighted, and double click on any field, the field automatically appears in the sort by window...

    Piano520 pointsBadges:
  • DB2 file names cause SQL error

    Hello I created metadata over a "set" of files. My next step is to define a primary over one of the files, and then foreign keys over the other files defined in my metadata relational database. Unfortunately, when I attempt to define my primary key over the main file, I receive an SQL error...

    Piano520 pointsBadges:
  • Convert data to character string in AS/400 query

    I use Query400 to output negative temperatures to a database file. The output file is currently created by the query at run time. The data is output as packed but I need the sign separate. I can't see how to convert the temperature to a character string either as the sign is ignored. Any other...

    Jubal5 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