• Retrieve remote directory listing via QSH

    Hello,I have a CL function which sends a .ZIP file to our client via SFTP.I have retrieved the size of the .ZIP from our IFS by using QSH to 'ls -l' the details and redirect this output to a data area from which I can extract the size. I now need to retrieve the size of the same file from our...

    Miffo170110 pointsBadges:
  • Upload Excel file from PC to iseries

    I need to Upload an excel file with (.xls format) from PC to iseries. So I have changed to CSV format . I have created a folder in QDLS folder and i have placed the excel to QDLS folder using iseries navigator. So using following command i have copied all the records to Physical file.Its working...

    22917510 pointsBadges:
  • The Line Feed *LF on the end of record

    Hi friends, How can I send a Physical File by e-mail not from FTP ?, I´m using Client Access but the end of record show CRLF. When I send this file by FTP to another server the end of record show LF. The problem is...My Boss requires this file in text by e-mail. Who helps me ? Thanks, PutzGrilla

    PutzGrilla710 pointsBadges:
  • Answer error message

    if has error message in rpg subroutine and we answer "G", that mean continue or repeat proses

    kopaska201225 pointsBadges:
  • export data in xml

    How do I export date from sql2008 in xml to a schema

    StephV20085 pointsBadges:
  • Determining data from a certain date range

    I have an Access 2003 database that has weekly dates and weights enter for a weight loss program. Ech program session is 8 weeks and people sign up for anywhere from 1 to many more sessions at a time. I want to find out the average weight lost in the first 8 weeks that a patient belongs, then in 16...

    HSwartzPartners65 pointsBadges:
  • AS/400

    as 400

    mmohan39320 pointsBadges:
  • need help on getting day of the week for given date

    I am using the below sql to get the day of week but i am getting :NumWeekDay as 0 I am using V5R3...can some help me on this to get the day of week. C/Exec SQL Set :NumWeekDay = DayOfWeek_ISO(:MyDate) C/End-Exec the above sql to get the day of week

    SOW110 pointsBadges:
  • Want all the PFT’S that have been applied in this 2012

    Want all the PFT’S that have been applied in this 2012 when i am giving go licpgm option 50 i am getting the detials from 6th month, can any one plese suggest me jow to do that

    Dinnu360 pointsBadges:
  • Power failure message was not monitored

    Hi All, Please find the log below.... CPF1816 80 INFO System utility power failed at 120725200228. QSYSARB5 QSYS 967606 12/07/25 20:02:28.866168 QSYS CPF1819 90 INFO System ending. Power failure message not monitored. QSYSARB5 QSYS 967606 12/07/25 20:02:29.208032 QSYS Can anybody tell me why the...

    venkatktata285 pointsBadges:
  • Pull Information from an as400 with a script

    I am curious if there is a way to have run a script that will log into all of the As400\'s I have and pull information down to an excel sheet. The information I would be interested in getting is serial number, ptf level, model/type, and if there is a way to change a basic user profile with a...

    rettub25 pointsBadges:
  • File Issue (Declared in OUTPUT mode)

    Hi All, A file (say FIL1) has been declared in outmode in a program A which is running continuously without ending and also writes the record in the file FIL1. There is an other program B which checks the record availablity in the file FIL1. But the problem is the problem A writes the record in...

    frmdeva365 pointsBadges:
  • Need a RPGLE program

    Hi, I want a RPGLE program which generate the next date. the input date format is YYYYMMDD...for eg. if we give today\'s ship date it would generate the tomorrow\'s ship date...it should exclude the weekend dates...I need it very urgent. Please help... simply i can say if we give today's date as...

    SOW110 pointsBadges:
  • How to scan document for printing with advance function printing

    We are a small manufacturer in nj. We make things like handles,washers and thumbscrews. We send an order to the production floor for a qty of some item with a picture of the product. The picture includes the measurements of the item and other details. These pictures have been scanned in somehow by...

    clubchamp5 pointsBadges:
  • moving a member from testing to production enviroment of as400

    how can i move a member of object from a library of as/400 testing to production environment? i have tried to used cmd savobj but it didn't work. can u give me an advice? or may be give me command of savobj for saving a member.. thanks 4 ur advice.. -aswin-

    Administrator180 pointsBadges:
  • Update duplicate record in rpgle

    I have a file where in filed1, field2 and field3 are key fields. Now these key fields are not unique, I need to update field 4, 5 and 6 based on the selection by user via subfile. To say f1 f2 f3 f4 f5 f6 A0123 A0123A *FILE CLM/D07 D07 1 A0123 A0123A *FILE CLM/D08 D08 2 A0123 A0123A *FILE CLM/D05...

    nasrunisar55 pointsBadges:
  • TCP/IP Host Table Entries

    When i enter TCP/IP Host Table Entries could see list of all server and their IP's. my question is these are the systems connects to BRMS network or there any other relation so they appear here?

    Dinnu360 pointsBadges:
  • Do we need to compile LF when its PF changes

    Hi, I have one small query. I have changed one PF, do I need to recompile it's dependent LF(s) ? For e.g I have earlier a PF say PF1 having 4 fields A,B,C,D (with keys A,B) now I have added a new field E. Do I need to recompile its dependent LFs say LF1,LF2.. Appreciate your quick response !

    pankaj2r100 pointsBadges:
  • Importing a .dbf file into IBM DB2 table

    I have a .dbf database file I want to upload to our IBM i5 and into a DB2 table. Is there an easy way to do this or am I going to need to convert the .dbf file into a .csv file? I\'ve tried using the CPYFRMIMPF command, but have had no such luck. Any help would be greatly appreciated.

    msoucy25 pointsBadges:
  • SST QSECOFR Disabled

    My QSECOFR Profile has been disabled after couple of wrong attempts with in correct password.Now,I forgot what actually the password is ...I'm trying to force DST with option 21 from HMC Interface to reset SST QSECOFR Profile...I'm getting DST log on screen when i force DST.Here also I forgot what...

    qmaster1,675 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