• RPGLE Embedded SQL Not null

    RPGLE Embedded SQL is getting a SQL0305 (SQLcid-305, sqlstate 22002) when fetching the next record from a view.  This is pointing to null values encountered.  /free                                                   exec...

    NickHutcheson11,380 pointsBadges:
  • SQL code made simpler

    I have 2 files that are clones - created by DUPOBJ. File_A is the original. File_BU is the copy. After I finish processing File_A, I want to update the same column (tSTAdm) in File_A when it is not equal to the same column (tStAdm) in File_BU. The file has a unique key – TsStat. I got the...

    PSMurray530 pointsBadges:
  • Printing Electronic Signature that is Printer Resident

    HELP!!!   I am trying to print an electronic signature that is printer resident on an HP printer attached trough the LAN.  I have the PCL Escape sequence from the manufacturer.  So far, I have retrieved the WSCST source, modified it to include an INDFNTE tage with a unique font id (used to...

    Tsladden45 pointsBadges:
  • CL Journal Checking Program (AS400)

    I would need help to write a CL program that accepts fields: a) From Time b) To Time c) From Date (This should be able to be *CURRENT) d) To Date (This should be able to be *CURRENT) I want to only select updates/deletes/changes to files (i.e. no I/O type access etc) Please suggest.    

    Mani1017130 pointsBadges:
  • AS/400 Query Job Log

    Dear all, Its my first time I submit a question so, please forgive me if I do something wrong. My question is if it possible to have a detail job log from a query. I mean if I can see what files I have used or what criteria I have used. Thank you Lambros

    Lambros25 pointsBadges:
  • Posts SFTP

    When you run the SFTP command from Qshell iseries mode I am presented with the following message: Connecting to 10.100.3.9 ... No user can not access! This message occurs with all users but a few. I want to know what caused this message, thanks

    Hueso9845 pointsBadges:
  • Mail Journaling Issue in Lotus Domino

    I have enabled mail journalling on two servers in our environment. Now every message which is sent to an id where some forwarding rule is enabled, the message is being journaled more than one time. I think this is happening because those rule are forwarding the mail arriving on that id to many...

    Mohit04125 pointsBadges:
  • New IBM monitors not created

    I'm trying to create a message monitor, setup works fine with no errors but when I click the OK button the monitor isn't listed in the window. I don't see the monitor anywhere, I don't get any messages, and there isn't anything in the joblog that even hints at an issue. I also tried a job monitor...

    Jim328100 pointsBadges:
  • iSeries SQL case on AS/400

    Is there an equivalent to case when exists on the as/400?

    Alanlev5 pointsBadges:
  • DBF in AS/400 – last record written

    Hi , There is  file which has 6 fields and the first four as its key. Is there any way to figure out which is the last record written into it.   Thanks

    Atti123135 pointsBadges:
  • Moving the unused source in AS/400

    Hi , I want to MOVE unused  sources from source PF . How can avoid copying individual memeber (opt 3) . Is there any coomand like MOVOBJ . I have the list of the sources and the source physical file name . Thanks , Bisht 

    BISHT321245 pointsBadges:
  • Wanna see IP or device name in OS/400?

    How can I see the device name or IP address of a person who disabled user profile by hitting wrong passwords in OS400 environment?

    Mkashifsiddiqui10 pointsBadges:
  • Clear AS/400 library

    library1                                 library2 pf1                                       lf3 lf1 lf2 i have 2 librares but i want to clear library1 all objects but not clear because depent objects are there in library how to...

    madhuchowdary350 pointsBadges:
  • FTP from z/OS PDS to server (how to add on .txt extension)

    I'm relatively new to FTP. Have written a JCL which will copy all members of a local PDS to a remote server. This process is somewhat successful, however all the same named filenames on the remote server reflect only the PDS member name (without any extension). Have used the LCD command to map to...

    Herb5 pointsBadges:
  • Configure SSL on iSeries

    [em]-configure SSH on the AS400 [/em] [em]-connect via a VPN from the desktop of a PC for a Client Access green screen session.  [/em] [em]Ian, they will probably want to connect 400 to 400, so as to transfer compiled objects across ie no source code for ‘restricted’ modules (only a guess)....

    Accenture130 pointsBadges:
  • HDDs protected or unprotected?

    Hello, After upgrading an existing 8203-E4A machine (i5/OS, V5R4M5) with 2x139 HDDs feature code #3677, i see in the "Work with disk units-> Display Disk Configuration Protection" that the model of disk units added are 090. The array is RAID5 and have 6 HDDs. 3 HDDs are 099, 2 HDDs are 090 and 1...

    Infoko65 pointsBadges:
  • Free IT Book: Achieving Extreme Performance with Oracle Exadata

    This week you could win a copy of Achieving Extreme Performance with Oracle Exadata from Oracle Press. Chock full of best practices for Oracle Exadata Database Machine deployment and maintenance, this resource covers data warehousing, transaction processing, consolidation strategies, maximum...

    MelanieYarbrough6,345 pointsBadges:
  • How to Monitor File Changes done thru STRSQL

    I need a solution for monitoring file changes done by programmers using the STRSQL from a command line for SOX purposes.

    poorboy01105 pointsBadges:
  • AS/400 Client Access

    Can you please let me know if i can download client access for free.

    0 pointsBadges:
  • Accessing the MICR font on an HP 8150 Printer

    Hi All, I'm having a problem using a printer resident font on an HP 8150 LaserJet printer. There are actually three printer resident fonts that I'm trying to use for a check printing process; a signature font, a secure digits font and the micr line font. I retrieved the PCL font list with their...

    Vince7720 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