• List of Values in a SP Parameter

    I need to pass a List of Values parameter from a Crystal Report to a Store Procedure. 1) How do I define the Parm? and 2) How do I code the WHERE clause? Example: Result Sets 1 Language SQL Begin Declare C1 Cursor with Return For Select * From Table1 WHERE Field1 in('Value1', 'Value2','Value3',...

    Saratusthra0 pointsBadges:
  • Syncronize DB2 email dist list with Lotus Domino v6.5

    A quick question that has us stumped here. Currently we maintian our email distribution lists in DB2 on our iSeries (810), running OS400 v5r2. We syncronize the dist lists with our Domino server (v5) using a migration tool Lotus provided. We are planning to update Domino to v6r5, and our iSeries OS...

    DWolfe0 pointsBadges:
  • Selecting and inserting library names

    Jeremy wrote in with this question recently: "Within an /exec SQL statement, I want to select from a file in one library and insert into the same file in a second. How should I refer to the library names? The editor rejects my attempts to refer to the libraries as host variables as per the...

    DebraTart0 pointsBadges:
  • Move from DB2/400 flat-file system to Oracle

    Rao wrote in with this question recently: "We are planning to move from a DB2/400 flat-file system to Oracle. We do not have any relations in DB2/400. I want to extract the Metamodel(total DDL scripts) from DB2/400 and go for data modeling. Initially, I thought Oracle Migration Work Bench...

    DebraTart0 pointsBadges:
  • Problems copying from a PF to a XML file using CPYTOIMPF

    Sanjeev wrote in with this question recently: "We are trying to copy from a PF to a XML file using CPYTOIMPF using STMFCODPAG(*PCASCII). The copy is not consistent -- sometimes it works fine and sometime it doesn?t." Do you have any suggestions that might help him out? -- Debra Tart, associate...

    DebraTart0 pointsBadges:
  • iSeries and PHP

    I am on a i520 running V5R3, I am thinking of using PHP to build some SQL query built web pages. I use PHP at home on Linux with MySQL so I think I have just enough knowledge to be dangerous. I was reading the RedBooks paper ?Bringing PHP to Your IBM eserver iSeries Server?. It appears to be...

    Verl8100 pointsBadges:
  • ANNOUNCEMENT ? MORE NEW CATEGORIES ADDED TO THE ISERIES CATEGORY

    UPDATE YOUR AREAS OF EXPERIENCE The following categories have been added to the AS400 ? iSeries section. Application development Systems management PC/Windows connectivity groupware & e-mail Career Opportunities for iSeries These categories were added last week: Backup & recovery Security Printing...

    DebraTart0 pointsBadges:
  • Advice needed to move from DB2/400 flat-file system to Oracle

    Koteswararao wrote in with this question recently: "We are planning to move from a DB2/400 flat-file system to Oracle. We do not have any relations in DB2/400. I want to extract the metamodel(total DDL scripts) from DB2/400 and go to datamodeling. Initially I thought Oracle Migration Workbench...

    DebraTart0 pointsBadges:
  • A DBA is required for the big iSeries server

    Search400.com member Fred wrote in with this statement recently: "Despite what IBM marketings says, I think that a DBA is required for the big iSeries servers." Do you agree or disagree?" -- Debra Tart, associate editor, Search400.com

    DebraTart0 pointsBadges:
  • Methods used to maintain the access path of a file

    Sarang wrote in with this question recently: "Can someone please name and define the three methods used to maintain the access path of a file?" Do you know the methods? -- Debra Tart, associate editor, Search400.com

    DebraTart0 pointsBadges:
  • Looking for a utility to list all used queries and files

    Pat wrote in with this question recently: "I need a utility to list all queries and files used, date used, etc. I am on V5R1." Can you point him in the correct direction? -- Debra Tart , associate editor, Search400.com

    DebraTart0 pointsBadges:
  • Anyone ever use the SNDRPY command in CL?

    I am using the CHGPF command to change a file. I know it will result in data loss, and I will get a messaage that I must reply "I" to ignore and then it will change the file. The file is used all day long and I would like to have a CL program change it after hours. I found the SNDRPY command that...

    Dalejanus0 pointsBadges:
  • SET verb in COBOL

    Hi The SET verb in COBOL set the value of a particular variable to a specified value. Now say I decalred a variable as 05 WS-SWITCH PIC X(01). 88 VALID-VALUES VALUE 'A', 'B', 'C'. 88 NOT-VALID-VALUES VALUE 'D', 'E', 'F'. If I want to set the value of WS-SWITCH as 'A', we can do as SET VALID-VALUES...

    Pgsdeb20 pointsBadges:
  • Data Integration

    We are in the beginning stages of integrating data between a PC based inventory system and the iSeries. Specifically we will be downloading and uploading data between the two systems automatically. We have had success using ODBC. We also need to be able to call an RPG program from the PC based...

    Christina0 pointsBadges:
  • DB2 Joins

    Can someone explain the order this join specification will be performed in? RSINDIP LEFT OUTER JOIN RSINDPP ON RSINDIP.INICID=RSINDPP.IPICID LEFT OUTER JOIN MKEMLAP ON RSINDIP.INCID=MKEMLAP.ELEMIC LEFT OUTER JOIN MKIPRMP ON RSINDIP.INICID=MKIPRMP.IKICID LEFT OUTER JOIN RSTHSTP ON...

    Intravler0 pointsBadges:
  • Accessing Oracle database on Linux from Mainframe

    I want to read some data from Oracle 9i tables running on Linux machine. Can some ne help me as I am not very expert on mainframe systems Thanks.

    Singhbb0 pointsBadges:
  • Printek printer using tcpip

    What does the spool file need to look like to print a barcode on a printek 4305 se printer? I cant figure out how to send the hex command to the printer so it understands that it is a command not just text.

    Cookie9340 pointsBadges:
  • Help running interactive SQL statement

    This user recently upgraded from V4R5 to V5R2, and now they're having difficulty running an interactive SQL statement that worked fine at R4R5. The statement is as follows: update grmlib/mspmp100 as t1 set pmfp2=(select pmfp2 from grmlib/sin gupl2 as t2 where t1.prdno=t2.prdno and...

    MichelleDavidson330 pointsBadges:
  • export sql server to iseries files

    when I attempt to export a file most vchar and char fields default to datalink type via odbc. The iseries does not like the datalink type as then it can't find the link. When I try to force the vchar field it creates the file but then on the copy tells me the field is not found Any suggestions

    AS400programmer0 pointsBadges:
  • QsnBeep

    Does anybody know if I can use the QsnBeep (QSNAPI) several times in a RPG-ILE but with different 'beeps'. For example, there are 2 possible errors in an interactive program, can I generate 2 different error-sounds ? Or does it ALWAYS uses the PC5250 host bell ? Although I think it is another story...

    Hahajokes5 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