• CTG opening programs

    What program opens to original contents of CTG Files?

    aff84air5 pointsBadges:
  • Easy way to identify DB file for specific data on screen (AS/400)

    I am trying to identify where a specific line of data is coming from when I am in a session. I've tried Shift+ESC+3+14, and all I get are active DB files. Is there a way to focus the search to one specific line of data and identify the source DB?

    mssanwo15 pointsBadges:
  • AS/400 DB2 Sav file

    Can an AS/400 DB2 Sav file be restored or migrated to MS SQL Server or Oracle? If not, can non IBM program or script be used to parse data from a SAV file?

    jknight275 pointsBadges:
  • Change Default on StrPrtWtr CMD within iSeries Nav.

    How can I change the default on StrPrtWtr CMD within iSeries Navigator?

    MaryM995 pointsBadges:
  • Create user profile other than QSYS library

    Can we create user profile other than QSYS library or QSYS is default library for creating user profile?

    anand12345610 pointsBadges:
  • DFU with VARCHAR fields?

    Can I use DFU to maintain VARCHAR fields in a table? If not, is there another easy utility that I can give users to add text to such a file?

    markhod5 pointsBadges:
  • Update and write sample RPGLE program

    Hi all, I have two physical files pf1 and pf2 with three field student_id,name,marks. I want to Move the records from PF1 to PF2. If the Student_ID already exists in PF2 just update the record else write a new record in PF2.where student_id is key field in both physical file. Could anyone provide a...

    nabamita90 pointsBadges:
  • DSPJOBLOG message for a individual session

    Just to be curious, any number of commands which we executed in the command line are shown if we took dspjoblog. Actually from where the dspjoblog command retrieves those information and shows to us. I tried with wrkmsgq (my workstation and also my user profile). I found nothing but the information...

    harish1990125 pointsBadges:
  • Spoolfile entry object/owner

    Is there a way to change the owner of a spoolfile entry? One user created the report and now a 2nd user needs to see it via Spool Explorer. neither has a full command line since we tightened security. Many years ago I would convert the spooler entry to a physical file and later convert it back to a...

    aceofdelts2,340 pointsBadges:
  • Promote a CL that uses TAATOOL utility

    Hi. I have some CLS written that use TAATOOL command. If I compile, it compiles well since TAATOOL is in the library list. However at the time of promotion it says compile fail, since it was unable to find the TAATOOL command.

    QaziHassan5 pointsBadges:
  • Problem with character alignment on output or retrieval of variables

    We have an issue we have never seen before but I'm sure happens all the time. We have a DDS screen where the character's are shown as follows:- RETAIL LOGISTICS                     : £99.00 RETAIL FREIGHT                         :£120.00...

    Sxlad200145 pointsBadges:
  • Job Log control in SMART400

    I've a batch job which call BO for each policy, this job generate a large number of job logs after it process some 1000 records(the number of records is not specific). It generate a spool files with around 200 pages, there is no error in the BO or Batch so it produce the output correctly. The...

    abhilashcem065 pointsBadges:
  • API Development

    We are seeking recommendations on an IBM premier business partner who would be able to work with proprietary software and develop API's from the major shopping carts and process the data to our order file which resides in DB2.

    Markk483065 pointsBadges:
  • How can I get system CPU usage and individual job CPU usage from database output of WRKSYSACT command?

    How can I get current system CPU usage and current individual job CPU usage from database file output of WRKSYSACT command. Which are the fields which store these values. I would like to write a program which reads the output (*file)of WRKSYSACT command. This program would send a message/mail when...

    JohnsonMumbai1,325 pointsBadges:
  • Mimix File Reorganization

    Looking for procedures to run file reorgs using Mimix Promoter. I'm not able to find appropriate commands or sequence.

    usfgwsmi5 pointsBadges:
  • CCSID 935 to CCSID 13488

    I have a file that is ccsid 935 containing some records with Chinese characters. I need to convert that file to its upgraded version that is ccsid 13488. (These are vendor files, therefore I have no control over their definitions.)  It is possible to simply copy the older file into the upgraded...

    Ckelly0120 pointsBadges:
  • How to track members in a logical or physical file

    Dear all, I have the question. Before the system was running full backup then Members name over 19,000. After the system was backup finish and Administrator's Application is missing control Members in PF/LF, so submit job (SBMJOB) many the jobs, such as everyone known, Maximum number of members in...

    Hvphong031160 pointsBadges:
  • Change interactive session to run under QCTL

    How can I change my interactive session to run under QCTL so my session when ending all subsystem to run IPL or need system in restricted state?  

    jjacques41495 pointsBadges:
  • Monitor SubSystem

    Dear all, Usually, I used command WRKACTJOB to track The jobs, and Press F5=Refresh and F10=Restart statistics to monitor subsystems and check as: CPU %, Status, Current User and fitter/sort follow CPU, Status I wanted to writer Script/Macro Code to monitor subsystem. Please can you let me know...

    Hvphong031160 pointsBadges:
  • How to retrieve the directory name from a string containing directory name/object name in clle.

    Dir1/dir2/dir3/dir4/test.csv. How to retrieve the directory name in reverse order. There is a huge number of records for which I have to get directory name in reverse order. Method that uses less time is required. Tried QSHELL Dirname that will output the STDOUT details to a database file. Here...

    NicyChn130 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.

Following