• Selecting Field Defined as L in SQL Server

    I am building 4 part SQL select across 4 files using union alls. All 4 files have a date field which is one of the fields I am selecting. My problem is that on one file the date field is defined as L type where the other three files have a date field defined as 8S 0. Since the field I am selecting...

    Canuhp235 pointsBadges:
  • CPF8361 Error after V6R1 Upgrade

    After upgrading from V5R4 to V6R1 we have begun to encounter CPF8361 errors related to Committment Control running embeded SQL.    Transactions get hung up in RDB and then processes get stuck.   Is this specifically related to the upgrade and is there a simple process to correct the issue. 

    Shadow4412265 pointsBadges:
  • Overlay and ‘print’ as pdf. Overlay not included !

    This statement OVRPRTF   FILE(MYPRTF)  DEVTYPE(*AFPDS) TOSTMF('/myapp/mypdfs')  WSCST(*PDF) beatifully generates a .pdf file and places it in the IFS-folder '/myapp/mypdfs'. ( ref:  http://www-01.ibm.com/support/docview.wss?uid=nas12bd8020c496ae912862575f400640da6  ) I have an overlay which I...

    DanTheDane2,555 pointsBadges:
  • SST password in AS/400

    i have installed V6R1 on my machine and i am not able to enter in SST whoever i have entered in DST and tried to change the password of my SST. I have not setup and ID and password for SST , please advise what do i need to do now, 1111111 and 2222222 is also not working.

    now225 pointsBadges:
  • Management Central running but cannot open.

    Management Central is running but when I try to open it I get "An unhandled win32 exception occurred in cwbunnav.exe" It opens a Visual Studio Just-In-Time debugger. Selecting Yes to debug doesn't work because the source is unavailable. Selecting No (and when exiting the debugger), the iNavigator...

    Jim328100 pointsBadges:
  • We have a COBOL application running on power6 , i 570 server with OS as V5R4

    We have a COBOL application running on power6 V5R4, will upgrading OS to V6R1 benefit in terms of performance.

    JohnsonMumbai1,160 pointsBadges:
  • Is message queue QSYSMSG still viable at releases V6R1 and above

    With all the new technology is message queue QSYSMSG still viable at releases V6R1 and above

    Shadow4412265 pointsBadges:
  • Edit mask on date field in AS/400

    Is there some trick that would allow using an edit mask on a true date field? I need to display a date in *USA format and allow the user to edit the date. If I convert the date to a numeric field, I can use the EDTWRD and EDTMSK keywords to accomplish what I want. If I display the date specifying...

    BWierman25 pointsBadges:
  • Find missing numbers with SQL

    In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

    DanTheDane2,555 pointsBadges:
  • Tracking IPDS printing on AS400

    How do I pass on user information to the printer from the AS/400? That is, if I wanted to embed user and job information on the IPDS job and send it to the printer, how would I go about it? 

    As400newton5 pointsBadges:
  • Why aren’t the Crystal Reports indexes showing since loading V6R1?

    I use Crystal reports via ODBC to the iSeries and have for years.  After loading V6R1 when I go in to create a report, the files aren't showing any indexes like they used to.  The used to show indexes based on the file definitions but now there are no indexes showing. I have even pointed the ODBC...

    DHardy5 pointsBadges:
  • Will the SQL performance improvements in V6R1 affect QUERY?

    Will the SQL performance improvements in V6R1 affect QUERY? Does QUERY use SQL under the hood?

    Fw15 pointsBadges:
  • Does V6R1 Support previous versions

    Does V6R1 still support older versions of IBM OS/400. E.g. does it still support IBM System36, IBM System 38, File naming conventions (TU.TABLE),relative files of System36 etc

    Nba5 pointsBadges:
  • Enherit column attributes when ALTERing column

    I have this: 1. A field-reference table (fieldref): CREATE TABLE mylib/fieldref ( A CHAR (10) NOT NULL WITH DEFAULT, B CHAR (10) NOT NULL WITH DEFAULT, C DECIMAL (7 , 5) NOT NULL WITH DEFAULT, PRIMARY KEY (A)) 2. A data table (myfile) created on the basis of the above fieldref table: CREATE TABLE...

    DanTheDane2,555 pointsBadges:
  • Problem with iSeries printer output

    Hi All, We have installed Iseries Access for Windows V6R1M0. But when we go to printer Output, it's very slow when we click any file, very slow, it's seem suspend. Please tell me how to slove that.

    QMP5 pointsBadges:
  • TCP1A77 error

    Hi, i do update my OS40 to V6.1 but since i have problem with my STRTCPSVR command when my system is in restricted stat. i got all the time the msgid TCP1A77 (TCP1A77 STRTCPSVR completed successfully; however errors occurred) so my backup counld't start without activiting manually the IP interface...

    junioras400250 pointsBadges:
  • unlock an IFS file

    I have an IFS file that the system thinks is being used by another user. I tried "check in" & RLSIFSLCK to no avail. How can I make this file available to use. As a work-around, I had the user open as read-only and save as another name, but I would like to use the original file.

    RayM265 pointsBadges:
  • IBM Disk Space Report

    On the report the total % of disk space is 86% which includes all unused space. Where is the other 14% which totals over 400Gb on our system ? IBM replied that it's because the data is in use at the time and the data gathering should be run in a dedicated system. I find it hard to believe that...

    Pmaddox140 pointsBadges:
  • *MGTCOL objects

    Can i change a *MGTCOL object into a PF so that later i want to send the data to a text file?

    ten20081,150 pointsBadges:
  • Dataarea as a variable

    Is it possible to address a dataarea by name from a variable field ? The idea is to keep last used report-no by dept/company in dataareas - one for each dept/company. Multiple dataareas (all *dec 7 0) are needed as report-pgm can print for several different departments/companies.  Dept-id shall...

    DanTheDane2,555 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