• SQL / DB2 Optimization (timing out)

    I put together a simple VB program to run SQL commands on any of our 4 I-series machines to return a simple grid view. I have run across a strange problem and was told it may have to do with optimization. For example if I run the following SQL ( I just want a count of parts (pm) that have not been...

    ToddN20008,925 pointsBadges:
  • CBR File Information

    I need to learn how to find the hexadecimal header and file offset of a file extension, specifically .CBR. Does anyone know what the hexadecimal and file offset are for such extensions and/or how to find them. Any help appreciated.

    Relentless5 pointsBadges:
  • Search argument for SETLL

    Hi! I have LF files to order addresses by: - name, city, state - city, name, state - e-mail, name, city, state. Search is made by typing some characters for name/city/e-mail. As LF-keys have different lengths, I indicate as search argument for the SETLL op-code a field whose length equals the one...

    argasoft100 pointsBadges:
  • Skip a error record and continue with the next record

    We have a MSGW job due to wrong date format (dd/mm/yyyy), need to skip the particular record and continue with next record. Can some one suggest the opt code to monitor the error and skip the record If possible a example code will be very much help full. Thanks Arun

    Arun12345678955 pointsBadges:
  • system date

    Hi, How to write a CL program. Provided--SAT/SUN/25th Dec /1st Jan are holidays. Then how to compare current system date with above holidays plus either of these days *TUE/*WED/*THU. Thanks

    6r1,485 pointsBadges:
  • Remote desktop connections

    Servers have Remote Desktop connection enabled. They work for a while. Then some servers will not let you remote into them until you reboot the servers. Then they work fine. Any suggestions as to what to look for. Thanks

    Bfsteel45 pointsBadges:
  • CPYFRMIMPF – CSV to flat file. Getting all blank records.

    All records in the flat file are blank when performing a cpyfrmimpf. Copy file command is listed below. DTAFMT is *DLM, FLDDLM is ',' A sample from the file in IFS is listed below. What am I missing. CCSID of file in IFS is 1252. CPYFRMIMPF FROMSTMF('/ITG/OGAZIP/districtzip.csv')...

    dpitts4619495 pointsBadges:
  • WRKUSRPRF

    Hi, is it posible to create a CL Programm or menu with WRKUSRPRF?

    Dollak25 pointsBadges:
  • Connect Direct sending reports from iSeries to Windows

    Hi all...Needs some advices on Connect Direct issue. I have tried setting on the WRKSPLMONE with using DSTFILE *SPLF and *GEN parameter. However, the results received at Windows naming convention are not ideal. The formal parameter will have naming as what base on the iSeries report file name. The...

    LeoKSW5 pointsBadges:
  • Server Group Policy

    I am running windows server 2008 r2 and Windows XP Pro on all client machines. I have just started in a school and noticed all the pupils have access to literally everything (not good one bit). I am wondering if i do GPEDIT.MSC and phobit most of the settings for the user configuration will this...

    kevinbillington5 pointsBadges:
  • How to find all the object authorization list assigned

    How to find all the objects authorization list assigned?

    Dinnu360 pointsBadges:
  • User Profile in AS/400 System

    Hi, how to find who has created the USER PROFILE and when it was created? Also What special authority need to find this? Thanks in Advance.

    Ipas4005 pointsBadges:
  • Is it possible to connect PHP to iSeries OS/400?

    I need to desperately connect our website (which uses PHP5/Apache 1.3/OpenBSD 4.1) to our back end system that is running on a iSeries OS/400 V5R3. We need to access several tables that are stores in there. But, I've run into some problems.First, the DB2 extensions / software from IBM can only run...

    ITKE343,740 pointsBadges:
  • How come I can’t use a single OVRPRTF?

    Can someone please explain to me why I can't use a single OVRPRTF in AS/400?

    bdibrell5 pointsBadges:
  • as/400 dspobdj

    I ran and saved the data after running dspobdj but don't know enough of what I'm looking at. What are the field names that are returned? I have a huge database and need to find the objects with zero rows.

    candytgr5 pointsBadges:
  • Read TIFF images from IFS directory

    How can I read a tiff image stored on ifs directory and display in a browser. I am stuck with two parts. 1. How can I read tiff images stored in ifs directory in a java applicaiton? 2. How to display a tiff image in a browser? I think browsers do not support tiff iimages. Should I convert them into...

    Veen7815 pointsBadges:
  • Export Arabic data from AS/400 folder to Excel

    How to export data from AS/400 folder containing Arabic data in to Excel

    Jaipalsingh5 pointsBadges:
  • Running Program (RPG) outside AS/400

    Hi, Is there a way I can run my RPG program on AS/400 without using or calling it on green screen?

    vantupert5 pointsBadges:
  • Host Variables in SQL Embbeded in Cobol

    I have this piece of code in SQLCBLLE source member: identification division. program-id. TST02. data division. working-storage section. Exec Sql Include SQLCA End-Exec. 01 TR01-REC. COPY DDS-ALL-FORMATS OF TST1PF. 01 TEST-REC. 05 WS-FLD1 like FLD1. linkage section. procedure division....

    LuisPedro5 pointsBadges:
  • Search in qualified data strucuture

    Hi, I used qualified data structure in RPGLE program. How to search in this data structure. My Coding: D Address DS D dvadd 20 D dvphn 20 D dvcity 20 D dvctry 20 D InvoiceInfo DS QUALIFIED DdvType1 1 2 DdvType2 3 4 D MailAddr LikeDS(Address) D ShipAddr LikeDS(Address)...

    LakNar270 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