• DTF to Excel in Batch file

    I have a Batch file (run from icon on desktop) that is running an IBM DTF to and Excel spreadsheet (file type: ASCII TEXT, translate data: ASCII) and then I use start excel.exe and it opens my spreadsheet with the data. PROBLEM: How can I format the spreadsheet with headers and column fonts and...

    Slmutone10 pointsBadges:
  • How to assign a job to a particular subsystem?

    Can anyone please let me know how to assign a job to a particular subsystem? Say I have 2 jobs. Job1 -should be driven to subsystem1 & job2 to subsystem2. I don't have any requirement in specific but just wanted to know how to accomplish this.

    juslikdat1440 pointsBadges:
  • What is the main difference between Subsystem & Activation Group

    What is the basic difference between an activation group and a subsystem? I have tried reading couple of blogs but I get confused. Can anyone please help me with this?

    juslikdat1440 pointsBadges:
  • perform IPL at anytime, when a backup is running in cluster(v7R1)

    How to perform IPL in iSeries server (Main server) when backup running in Cluster (backup server). I want to perform IPL at anytime, including when a backup is running in cluster. Is there any consequences if we perform IPL when backup is running in cluster? Please provide me the procedure and...

    venkatktata285 pointsBadges:
  • Unattended install of Client Access

    Can you do a unattended install of Client Access?

    sdubois20005 pointsBadges:
  • AS/400 pass through query from Microsoft Access

    I am trying to build a pass through query in Microsoft Access. I am trying to retrieve data from a file that has multiple file formats. Here is the code I have so far in my pass through query: SELECT h.lhamt1 balance, h.lhnote account FROM bnkprd01.lnp007 h WHERE h.lhtc1 = 33 AND h.lhposj BETWEEN...

    lionbank5 pointsBadges:
  • Retain the values in the inital screen after coming back from the popup window

    I have a screen which displays the account numbers. If i input some values to this account field and when i do an F5(without hitting enter) I can see the popup window, but after coming back from the pop up screen, my account numbers are gone. I have used CA05 for the popup. If I use CF05 and then...

    RamvishakRamesh2,505 pointsBadges:
  • Physical file

    While compiling physical file, it is submitted to Batch. I don't want to submit to Batch. Please give me a solution.

    421380 pointsBadges:
  • Printer file

    Is printer file a object? If so then please tell me the object type.

    tanmoysaha10 pointsBadges:
  • Popup window is not displaying any field values in subfile

    I have a requirement like this. From my display file, when an F5 is taken, it should display a subfile. It is displaying the window with the SFLCTL fields, but no values for the subfile field. Can anyone help me here to identify the problem? This is the DSPF code A S@PRODD5 70A O 8 3...

    RamvishakRamesh2,505 pointsBadges:
  • Changes that could affect intial menu to override Authorization list for a user profile?

    Recently, In our shop we noticed that a particular user profile has access to some of the restricted libraries. We are using Infinium ERP, and have AMCIU intial menu. Somehow, this appears to be broken due to which this user is able to update some of the restricted libraries. I want to know how...

    Meetmeonline210 pointsBadges:
  • Any keyword to show a line on the subfile (Window subfile) after the heading?

    In my Window subfile, after writing all the header part, I want to show a line. Instead of coding 5 1'----------------------' is there any other keyword for that?

    RamvishakRamesh2,505 pointsBadges:
  • Spool file too wide for PDF

    I am creating a spool file as a PDF. The spool file has a width of 198, but when it is created as a PDF about 20 columns on the right hand side are truncated. When the spool file is sent directly to the printer the font is reduced correctly to fit the report on an A4 page in landscape. But this is...

    MarBak35 pointsBadges:
  • Script on AS/400 MAM Console

    Could you help me create script for AS/400 MAM console? Script should check first line in console (every minute) and delete it IF the same text exist in other text file.

    osas4001120 pointsBadges:
  • Query in AS/400

    I want to know how I can use the query in the AS/400?

    mohamedhafez35 pointsBadges:
  • How to change a field description

    I plan to re-use an unused field in a PF. Of course, I want to give it a new COLHDG. My question is ... how to do this without re-creating the PF? I did this once (4 years ago) but I don't remember what command I used to make it "take" (just changing the source code would not be sufficient)

    aceofdelts1,870 pointsBadges:
  • Viewing stored procedure statements in AS/400

    Hi, I created many stored procedures using STRSQL. And I called those procedures using SQLRPGLE program. It worked but I need to view those statements. I don't know how to view stored procedure statements which was created using STRSQL. Can anybody help me?

    LakNar270 pointsBadges:
  • Reset Password of a UserProfile

    Hi Group, How do we reset the password of a UserProfile in AS/400? Regards, M

    mvrkrishna535 pointsBadges:
  • iSeries query: Compare two fields in one file

    Try to do a multiple select statement and then compare the results of that statement. See below: SELECT "T16.APAR".P._PARCEL_NR FROM QS36F."T16.APAR" WHERE "T16.APAR".P_PARCEL_NR NE "T16.APAR".P_PARCEL_NR (SELECT "T16.APAR".P_PARCEL_NR FROM QS36F."T16.APAR" AS "T16.APAR" WHERE "T16.APAR".P_YEAR =...

    lorit365 pointsBadges:
  • Problem with the READ from PF in RPGLE

    Hi ! Im trying to read a physical file from my RPGLE program. That physical file having many fileds. AGCDE is the one of the filed there. The AGCDE data is from 001 to 700. But i just added it randomly. Now im having a problem with READ in RPGLE.. When i call the program its reading the Physical...

    Sureyz2,380 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