• Using CVTPFXLS to convert a datafile

    Can anyone help here please. I am using the CVTPFXLS command to convert a datafile to xls but the negative packed fields are not getting translated correctly. The negative signs are dropping out. Cannot see any options on the command. Cheers!

    tjgm88995 pointsBadges:
  • STRSQL command

    Can you use the STRSQL command within an AS/400 CL program?

    Pb5410 pointsBadges:
  • STRSQL query

    I need to know how to get the record count for a particular year. the date field is in YYYYMMDD format. I tried the query select SUBSTR(PLGLDT,0,4) AS YEAR, COUNT(*) AS "RECORD COUNT" FROM BPCSF60/APL GROUP BY SUBSTR(PLGLDT,0,4) ORDER BY SUBSTR(PLGLDT,0,4) DESC. But I am getting error "Argument 2...

    vibgyor280 pointsBadges:
  • AS/400 query by date

    How can I search a iSeries query by date?

    STCA60 pointsBadges:
  • AS/400 query for logical file

    I have one join file and one logical file. It is possible to create logical file on join logical file?

    anupsshelke420 pointsBadges:
  • Opcode in RPG that retrieves current date

    Which opcode in RPG can be used to retrieve current date along with century?

    Vids295 pointsBadges:
  • Current date in DB2/400

    IN DB2/400, is there a field level keyword for showing the current date?

    JIJUKALLIATH5 pointsBadges:
  • Calling programs information in RPG

    I have RPG program which consists around 7,000 lines. Is there any way to see the calling programs from the main program. One way is to manually searching the calling program name in main program. But it also taking so much time to know. So is there any way or command to get the all calling program...

    sivakesava280 pointsBadges:
  • Converting a character to numeric

    In WRKQRY environment, what is the function that can be used to convert a string or character to numeric? By Sulaiman "Sem" Salomon Bernat

    SEMSBERNAT5 pointsBadges:
  • Stop and Start AS/400 TCP/IP

    How can I stop/start TCP/IP??

    ZOS5 pointsBadges:
  • Error while using STRSQL

    When I run the following command I get an error while using STRSQL. Is this a valid statement or am I losing my mind. select right(gmans, 5) from f0901 (This is the error I get) RIGHT in *LIBL type *N not found. If I use the "Left" command it works fine.

    Rontracie0 pointsBadges:
  • AS/400 overlay form problem

    Hello, I have had to change an overlay (specifically a phone number created) in Microsoft Word 2003. I have uploaded the .prn to the AS/400 and created the overlay. However when I run the program to print the overlay form the data has shifted out of alignment mainly down and to the left! Can...

    Aliw10 pointsBadges:
  • AS/400 Overlay Problem

    I need to change the wording in an overlay, how do I get the printer to recognize the new updated overlay?

    jdw10 pointsBadges:
  • How can I make sure all new and changed objects are being backed up when using the SAVCHGOBJ command?

    Our current backup procedures include a full system save once a week (SAT) and two daily save change object processes (M-F). Yesterday a new library added on Monday was deleted by accident. When trying to restore it from one of the daily tape backups which was done using the SAVCHGOBJ command it...

    Showme35 pointsBadges:
  • QMQRY!

    How can we run multiple select/update query via a single QMQRY?

    sgautam11105 pointsBadges:
  • Why did the system crash?

    Forgive me if this is hard to read but editor looks messed up again (tried using all 3 browsers). At a loss here. We had a user working remotely through a VPN last night. Around 19:00 last night they lost the connection running a query and did not try logging back on. At 19:17 I see a message...

    ToddN20009,815 pointsBadges:
  • QCMDEXC error

    Hi, I have built a small application using CL to convert date to required format. When I want to accomplish the same from RPGLE program with a display file to input date I wanted to call CVTDAT command from the RPG program. But I am getting error saying this command can't be issued in this set...is...

    ten20081,150 pointsBadges:
  • QCMDEXC API

    What are the commands which can't be executed using QCMDEXC API?

    6r1,520 pointsBadges:
  • How to create a SQL view of the file

    How to create a SQL VIEW of the file to present packed or binary values as characters? I know we can create an sql view using CREATE VIEW library/view1 AS SELECT * FROM library/filename.  But can anyone tell me how to present packed or binary values as characters using this? I used the command...

    vibgyor280 pointsBadges:
  • SQL view & FTP of this view

    I need to create an SQL view & do FTP of this view. CREATE VIEW palib/reshgjw AS SELECT WJWID as WJWID,char(WPEROD) as WPEROD,char(WCMPNY) as WCMPNY from libname/filename. In my text file, I need a tab b/w each fields. But in the text i got there are no field separators b/w field 1 & field...

    vibgyor280 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