• Is a special authority needed for active socket connections?

    Audit log entries for the user QTMHHTTP of type AF subtype K are created, if a PHP script requests a socket connection like LDAP or HTTP with CURL. Does QTMHHTTP need a special authority for this? Which one: *IOSYSCFG, *JOBCTL ... ?

    Gfroehlich45 pointsBadges:
  • Web query options not displayed

    I am working through the Redbook on Web Query. I have logged on as an administrator through the browser and created a new domain. Next step is to create metadata and that should be accessed via a drop down menu on the reports folder. The only options I have when I right click the reports folder is...

    FrankStacey105 pointsBadges:
  • Problem converting numeric to date data type

    I have a zoned decimal field as s 6 and i am trying to convert it to date format as mmddyy in sql...It giving error ..please help me out ..I tried using date and cast function but its not working !!

    munduuu435 pointsBadges:
  • Open list of Objects using QGYOLOBJ API

    Hi, I'm trying to use the QGYOLOBJ API to get all the objects from one type but always gave me invalid results into the List Information str:   struct SelectionControl {     Qgy_Olobj_SelControl_t selControl ;     char status; }; struct Receiver {     Qgy_Olobj_RecVar_t receiver ;    ...

    GraceP415 pointsBadges:
  • Passing parameters RPG-CL-RPG

    I am trying to modify an intermediate CLLE program to submit itself to batch. The calling program (ILE RPG) passes a parameter as a character field with a number in it. The CL program receives it as a numeric field and then calls another RPG program and passes that parameter. The final RPG program...

    Vatchy1,410 pointsBadges:
  • .MSI file in vb6.0

    How to create .MSI file in vb6.0 ?

    Ankurd15 pointsBadges:
  • Get the ASPs with QYASPOL API from c++

    I trying to get the ASP with the QYASPOL API from c++ but the next source code only  returns data in the info variable , the receiver looks empty :S , could you point me in the right direction ?  #include <QYASPOL.h>  #include <stdio.h>  #include <qusec.h>  #include...

    GraceP415 pointsBadges:
  • Work with PTF Groups showing 2 Cumulative PTF Packages.

    Hi, When i displaying Work with PTF groups it is showing 2 Cumulative PTF Packages C1137540(PTF Group SF99540) and C7016530(PTF Group SF99530). Both are showing installed. Do i need to get rid of one. Also in WRKPTFGRP i have many PTF Groups with status NOT APPLICABLE. Is it safe to get rid of...

    Nikhilsood40015 pointsBadges:
  • Reversing a String in RPG

    Hello Sir, I am new in as400 programming area, In an interview I was asked How to reverse a String in rpg. I wrote the fixed lenght string program but don't know how to write it for Variable length string. I an declaring an array in RPG as:  DStringR          s             15A  ...

    Neeti5 pointsBadges:
  • Confused about the career path

    From last 4 years i am a technical support engineer dealing with AS400 servers and bmc patrol and remedy. Well my organization is giving me an opportunity to switch to QA. I dont know what to do.. There are two options now in front of me either switch to Software Testing or learn more about AS400...

    Tbhushan5 pointsBadges:
  • Same file in different libraries and file is defined once in an RPGLE program

    I have a coding project that requires the following.

    aderene180 pointsBadges:
  • Download AS400 Physical File to Excel Using VBA

    I am in the process of developing an Access database with the intention of using it to control the download of AS/400 physical files into Excel. I am fine developing the Access / Excel side of the data, however I ahve no experience with the AS/400 side of things. The access database will contain...

    Martyjw5 pointsBadges:
  • If Statements

    how to look up numbers only?

    R123456s5 pointsBadges:
  • Can you “read” a fax or email/attachment with a program or 3rd party tool?

    We are in the beginning phase of a project to fully automate a shift (yes-and get rid of a position). One of the things that the person does is review and compare a fax, email or email attachment to a file that is FTP'd to our SYSTEM.  [o:p][/o:p] Way back in time I worked on a project that...

    Camcolt1115 pointsBadges:
  • SQLCODE 30 on fetch SQLRPGLE

    Hello All,  I'm trying to execute a fetch into DS on a SQL statement and keep getting code 30: Number of host variables less than result values. The DS and SELECT statement both have the same number of values as far as I can see.  Here's the DS and select fields code: D ClaimRecDS      ds  ...

    Dcantwell470 pointsBadges:
  • Execute SQL SELECT via RUNSQLSTM error

    Trying to execute SQL-statement "SELECT * FROM mylib/myfile" give errormsg SQL9010. Some say that SELECT is not supported with RUNSQLSTM, but IBM command parameter text indicates otherwise. Is SELECT supported and what am I doing wrong?

    DanTheDane2,555 pointsBadges:
  • SQL400 Strip non-numeric from a column

    Hello everyone, Is there a way to strip non-numeric characters from a char column? Example: I have a Clients file, with column "Telephone Number" (CLPhone, 20, A). The thing is, phone number for many clients is filled with different formats. Example1: (123-12345) Example2: 123 12345...

    Builder40060 pointsBadges:
  • Redundancy Misconfigured in iSeries-SAN

    Oops..new DASD from SAN was misconfigured and loosing redundancy... There are the New Multi Path connections to the SAN for one of the IsERIES server.. note that the Redundancy connections are using the Same BUS.  This unfortunately now gives us a single point of failure down to the Fiber channel...

    qmaster1,675 pointsBadges:
  • Calcing quartiles using the median

    I'm using this SQL to determine the median of a group of temperatures... select x.TEMP from QGPL/WEATHER1 x, QGPL/WEATHER1 y group by x.TEMP having sum(case when y.TEMP <= x.TEMP then 1 else 0 end)    >=(count(*)+1)/2 and sum(case when y.TEMP >= x.TEMP then 1 else 0 end)>= count(*)/2...

    tegarvey35 pointsBadges:
  • ASP – Response.Write Object

    Hi. I am using the ASP tutorial in www.w3schools.com. When i try out the following basic example it is not showing any results: <html> <body> <% response.write("My first ASP script!") %> </body> </html>   [!--response.write("My first ASP script!") --]I have tried...

    JKJK45 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