• SQL Plus stops before finishing

    Why does SQL+ stop after running so many characters in a long SQL statement?

    rayfish201315 pointsBadges:
  • iSeries SQL Cobol

    In my COBOL SQL select statement that was previously running on V5R4, I was able to extract a date field defined with "date" as the data type. We are now on V7R1 and we get a data mapping error. No clue as to why? Any ideas? thanks

    Pgmr4655 pointsBadges:
  • DYMO LabelWriter 450 local printer troubles

    We are no longer able to print to our label printer. The PC we were using had to be replaced. We need to know how to set up this printer so it will print addresses via USB connection. I downloaded and installed the correct drivers for the printer. I used printer model *WSCST to configure the...

    Stigapproved30 pointsBadges:
  • Journal Before/After image not in plain text

    I have a journaled file that I need to review the before and after image of a field change. When I look at the field, the characters in both the before and after images are unreadable (strange characters, blocks, etc.). How do I view the journal image in plain text, or convert it to plain text?

    CollickB40 pointsBadges:
  • Updating a physical file

    Suppose I have a RPGLE Program P1 And P2 and a physical file PF1 . P1 using PF1 in update mode and p2 also using Pf1 in update mode. When P1 calls P2, it throws an error saying file locked. What can be done. I need to update pf1 in both the progs.

    jainamit380 pointsBadges:
  • webservice and iDB2 connections slow on startup

    We have a web service running on a SQL server sending data to our I-Series using a DB2 connection. The first time the service is run to submit an order, there is a long delay before it is submitted. On repeated orders it much quicker. Is there something we can do to speed up the initial connection?...

    ToddN20009,915 pointsBadges:
  • Data missing in CPYTOIMPF

    I am doing CPYTOIMPF FROMFILE(MIUOALLV1/LSJSEP) TOFILE(QTEMP/LOWA5P) + TOCCSID(*FILE) STMFCCSID(*PCASCII) + STRDLM(*DBLQUOTE) FLDDLM(';') + DECPNT(*COMMA)) Where LSJSEP is a file with 50 fields , total length of the fields is arounf 1500 , LOWA5P is a file with only one field of length 12000. The...

    asakla240 pointsBadges:
  • Sending Japanese characters from Websphere Message Broker to iSeries

    We have a requirement to send data from WebSphere Message Broker to an iSeries via MQ. The message triggers a call to an RPGILE program which will process the message and write the data out to JD Edwards database files. The messages on the broker are encoded as CCSID 1208. The iSeries OS has a...

    tonyflavell10 pointsBadges:
  • How to read from flat file

    How to read from flat file For eg: The data in one flat file is like this D|EMPN0001_001_01|C55BFIT|.00|.00|GBP|Y|1.00|20030101|20130301|IT|||||LC|100 D|EMPN0002_001_01|C55BFIT|.00|.00|GBP|Y|1.00|20030101|20130301|ECE|||||LC|100 The data in another flat file is like...

    Prashanth123255 pointsBadges:
  • Run system 7.1 on power 6 550

    Hi, Please can anyone tell me if we can run 7.1 system on power 6 550. Thanks

    ASZ10 pointsBadges:
  • Reset/CTRL in a Macro in AS/400

    I'm trying to write a macro that fills in a list of items with a list of properties. My only problem is I cannot find a way to reset controls (if I look at my key bindings, left ctrl is bound to [reset/ctrl]) I have tried many combinations of a few available functions, nothing works to clear the...

    TaylorAnim5 pointsBadges:
  • Size of a save file in AS/400

    Hi, I would like to know is there any way to find out the size of a save file in AS/400 in bytes.

    didinu760 pointsBadges:
  • DISPLAYING HELP TEXT OF A PROGRAM IN AN INTERNET EXPLORER WINDOW VIA RPGLE

    Hello all, I was wondering if anyone has had any experience in using Internet Explorer in conjunction with RPGLE programs. Now, I'm not looking to go out to any internet site, instead, my boss wants me to create something for our user community. While in an Interactive Program, if the user hits F1...

    Eric Witham690 pointsBadges:
  • What will be the port number using for Canon printers from AS/400

    What will be the port no using for Canon Printers from AS/400?

    Libish5 pointsBadges:
  • IF loop

    key1 chain file1 if %found(file1) elseif key1 chain file2 Can anyone let me know whether the above if loop is correct or not?

    JSDHFKJHA335 pointsBadges:
  • SFL

    I have a SFL. In which I have a option selection field. I have used reverse image indicator for it. But when I insert a wrong value in that field, then the entire column is highlighted instead of the option selection field for that particular record. What should I do?

    jainamit380 pointsBadges:
  • Indicators in RPG

    HI, I am a cobol400 developer and new to RPG and curious to know much about RPG... My question here is In what scenarios we use the below indicators 1.Overflow indicator 2.Record Identifying indicator 3.Control level indicator 4.Field level indicator 5.Resulting indicator Thanks in adv Anup

    anuppdas105 pointsBadges:
  • True type fonts – AS/400 v6r1

    which directory do I have to place my true type fonts

    gregedy10 pointsBadges:
  • Canon ImageRUNNER on iSeries printing to specific mailboxes

    We have connected a Canon ImageRUNNER to our iSeries via the network.  I have created a Workstation Customization Object to send reports to a specific mailbox and can't get the PJL code to work.  I know the system is recognizing the Workstation Customization Object because I can get it to switch...

    KarenM15215 pointsBadges:
  • How to assign only specific menus in SST to particular user.

    I would like to give authority to specific menu/tasks from SST to a specific user. For Eg: Access to SAL, PAL & Display/Alter Dump menus from SST. How can I do this? Regards, Ketan Sheth

    Ketan19305 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