• lock out access to communications drop down menu in client access emulator

    We need a way to prevent users from changing or creating .WS files.  The reason is that we have an external application that prints the patient arm bands to a printer based on an external table which uses the WorkstationID to Map printer.  Users are always modifying this and breaking the...

    KatanaBeach115 pointsBadges:
  • If Function

    is there ONE multiple IF function formula to inclue all of the below if INS = nd and order is less than 5000 then 0% - - if INS = nd and order is 5000 to 11999 then 70% - if INS = nd and order is 12000+ then 8400/order if INS has a value then INS/order

    Newinfrance15 pointsBadges:
  • embedded sql update

    I have a prog that should update all KY cust master records with the new code AR. I run the program but nothing happens. The file remains unchanged. I am new to embedded sql so what am I doing wrong ?? D OLDWH           S              2    INZ('KY')    D...

    ToddN200096,960 pointsBadges:

    My test program uses STRPCO and then STRPCCMD PCCMD("C:test.bat").When I call the program twice,it will ocurse error.Error message likes "Client access AS400 Oganizer already active in device XXXXXXXXX".I don't know why.Thanks.

    AS400STRPCOERROR5 pointsBadges:
  • Any Better substitue for RCLRSC?

    We are getting error message when we change the libraries in succession in AS400 (libl rpl command is used). Our AS400 systems were upgraded from V5R3 to V5R4 last year. We did not face such issues previosuly in V5R3 version. Could someone please let me know if this error msg is due to Version...

    Charanya5 pointsBadges:
  • client access problems with v5r0m0 & windows vista

    i have problems for connect my pc windows vista with pc5250 and transfer with as/400 os V5R0M0. can you help me, i know that this version is very old, but i don't have other option of comunication.

    Capelo5 pointsBadges:
  • How to make a batch job run faster (excpet for the run priorty), Code changes?

    HI, I have a batch RPG programs used to do some updataions and reporting, currently the job takes around 1 sec to process a record. We want to further reduce this time. Changing the run Priorty may make the job run a bit faster, are there any other parameters that can be used? also am looking at...

    Caprius0 pointsBadges:
  • How can you get the replace option on the as400 DBU to work?

    I needed to massage a file to change a field from 1 to 001. It would of been an easy excersise if I could of got the replace option of as400 DBU application to work. The online instructions have a large amount of intell about how to search but nothing I could find about the replace utility. thanks

    nitzinger385 pointsBadges:
  • how to load client express on window 7

    how to load client express on window 7

    Zman10 pointsBadges:
  • Message Monitoring

    My manager wants me to be able to monitor messages for our two AS/400s. Is there a way to send break messages to my desktop for the qsysopr messages. I have to remember to display messages every hour to see if there are any messages requiring a reply.

    TRFCTL20 pointsBadges:
  • AS/400 Query – Timestamp of entry to char field

    Hi friends, I am creating an account file with the command below: DSPJRN JRN(QSYS/QACGJRN) FROMTIME('26/09/2009') TOTIME('25/10/2009') ENTTYP(SP) OUTPUT(*OUTFILE) OUTFILFMT(*TYPE4) OUTFILE(QTEMP/QAPTACG4) How can I convert the Timestamp field called JATSTP to a new char field with the first four...

    RBDSILVA550 pointsBadges:
  • need a process to obtain set of records updated/added out of 100million records

    Hi, We need you suggestion in the following design. We have a file with 100 million records.This file is updated on daily basis by more than 50 jobs.We would like to obtain the set of records from those 10 millions records, which are either updated or created on that day.Since we don't have any...

    Sugaar0 pointsBadges:
  • Date Keyfield in a Physical File

    Hi, Is it possible to have a Date as one of the Keyfield in a Physical File and access the same in a RPG/RPGLE Program using the KeyList?

    Cganeshh0 pointsBadges:
  • WRKJOBSCDE every *other* week

    Does anyone know how to use the IBM scheduler to submit something every *other* week or every third week, etc? Thanks, Kevin

    TylerDurden0 pointsBadges:
  • SNDDST TYPE(*DOC) not working for big files

    We are using SNDDST to send reports via internet e-mail. It works for small reports (text files) but not for larger ones. No error is shown when issuing the command. QSYS/SNDDST TYPE(*DOC) + TOINTNET((sbchenry@hotmail.com *PRI)) + DSTD('Sending a Text') + MSG('Find the report attached.')+...

    SBCHenry30 pointsBadges:
  • Stored Procedures on AS/400

    Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? Thanks...

    Ashnirody100 pointsBadges:
  • Retrieval of Extended Source Library Information

    Is there a way via FTP to retrieve additional source code line-level details (sequence #, date line of code was changed) from iSeries RPG/CL source libraries? If not via FTP, is there another way to extract and transfer this information?

    Rchapin0 pointsBadges:
  • Help with converting Mainframe file on iSeries

    Hi there, I'm looking for some advice/help on a file that I'm having some trouble with. The file originates from a mainframe, and is sent over to our iSeries (V5R2M0) via Connect:Direct. The file is 3680 Bytes long, comprising of string and compressed numeric data. I have the layout of the file,...

    Nealhudson0 pointsBadges:
  • AS400 name not resolving in DNS

    On Sunday I restarted my AS400 prior to doing my monthly full system back up. When it came on line, none of my PC's could resolve the system name (s10a####) to the internal ip address. I entered a DNS entry manually on my internal Windows 2003 DNS server, and all the PC's running XP pro can connect...

    Sidzilla0 pointsBadges:
  • The IT Blog Top 10: Dec. 10, 2009

    10. No Exchange 2007 on Windows 2008 R2 – but why? Brendan Cournoyer delves into why the latest Windows 2008 R2 takes a surprising turn in not support Exchange 2007. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8....

    ITKE1,062,890 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.

Thanks! We'll email you when relevant content is added and updated.