• URGENT!!! file field decoder generated on AS/400

    REALLY URGENT!!!!!!!!!!!!!!!!!!!!! How can i view the contents of a packaged field? I send an example of the chain. I need to visualize the contents of the little squares: 5 1 91010 491997 9801011L 980101 1 1021023 102 103 100 DTO CARULLA DTO CARULLA DTO CARULLA 0 1 0 11 K 1TQ 15% Q TQ NAL T TQ NAL...

    Onasis0 pointsBadges:
  • Error in a Group of Called Programs

    Hi, I have a CL program, it calls 10 other programs i.e. pgmA, pgmB, pgmC.......so on...10 programs. While running the CL program error occurred in pgmC. I rectified that error. After rectification once again I will run the CL Program. Now my execution must start from pgmC. How do i do this???...

    0 pointsBadges:
  • Question on Workfile

    Hi, Please could any one help me getting answers to these Questions.... What is the diff. between Workfile and PF? How do u create a WorkFile in RPG or CL. What are the advantages of WorkFile over PF? Thanks Rama

    0 pointsBadges:
  • Sorting out missing out

    I have 2 files. One having 1000 records and the other 1350. I need to sort out the missing records and place them in an excel sheet. Programmatically how to acgieve this???

    0 pointsBadges:
  • Sorting out missing records.

    Suppose i have 2 database files. one with 250 records and another with 350 records. There are some common records in both files. How to get the missing records?? Is this possible with CPYF command. If yes???Please explain me how to get this. or Is there any other to achieve this. Thanks and Regards...

    0 pointsBadges:
  • How can I find on which files a program has been attached as an external trigger?

    I have a "generic" rpgle program that can be attached to any physical file as a trigger. And so it has been, many times.. Is there a utility that I can use to find exactly what files have this program attached as a trigger? Or some table where I can look? Thanks! Kevin

    Beercheck0 pointsBadges:
  • GENERATED KEYS…

    I want to generate the next avalable key when INSERTing new rows. For an example... Create Table DBALIB/PARENT ( PARKEY BIGINT NOT NULL WITH DEFAULT PRIMARY KEY, PARNAME CHAR (30) NOT NULL WITH DEFAULT); INSERT INTO PARENT ( PARKEY, PARNAME) VALUES ( PARKEY(MAX) + 1), (<=====> just for...

    Znason460 pointsBadges:
  • Front End Development for AS400

    Hi We have an application in AS400 for which we are thinking of developing a GUI front end for the users. The users will then be able to run the processes from their PC. I have not worked on any such application and so, I do not know anything of that. I have done some initial research on that and...

    Pgsdeb20 pointsBadges:
  • SQL Logical Functions

    Which is better to use and why? Also, which function is faster and why? Coalesce -or- IfNull

    maryann465 pointsBadges:
  • Using an array in embedded SQL in RPGLE

    Is there a way to specify a host array element in a where clause in embedded SQL? This is what I am trying to do: C+ Where TkPart01 = :odPart(01) C+ and TkQty01 = :odQty(01) C+ and TkPart02 = :odPart(02) C+ and TkQty02 = :odQty(02) There's more to it than that but that should give you the general...

    Vatchy1,410 pointsBadges:
  • Db2/AS400 library connecting via oledb in vb.net

    I have been trying to connect a vb.net datalink property to a specific library on a 400. When I fill in the field "Enter the initial catalog to use" I get the message that the catalog is invalid. I have thought it might be a path on the 400, such as QSYS/MyLib, but that errors as well. What am I...

    Vatrix0 pointsBadges:
  • MS SQL Server 2000

    Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

    Sudh2k0 pointsBadges:
  • can strqmqry be run as remote command

    I am trying to run strqmqry via a dos/cmd ftp session. command: QUOTE RCMD STRQMQRY QMQRY(lib/qry) ... where ... are other options I followed various instructions posted here and on as400 tech sites on how to create the query. I was able to do all of that via a dos/cmd ftp session (except for...

    Bdatadigger0 pointsBadges:
  • OPNQRYF’s MAPFLD

    I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined this way...

    JohndeCoville0 pointsBadges:
  • SQL Stored procedure call via ODBC

    Trying to call a stored procedure via ODBC, the CA400 ODBC driver uses the SQL (as opposed to SYS) conventions this works fine when procedure is created in QGPL and procedure is called with CALL QGPL.MyNewProcedure(Parm1,Parm2,Parm3) when the procedure is in another library then the call does not...

    Teckgeck170 pointsBadges:
  • Creating DB2/400 Table Dynamically

    Hello, I need to create DB2/400 table from CL or COBOL with some column names which are defined dynamically. How to do this ? Thanks

    NarasimhaReddy225 pointsBadges:
  • Isolation level… Join new JAVA development with old, outdated COBOL code…

    Anyone have experience dealing with JAVA and isolation levels? The concern or talk at this shop is how to handle current old COBOL code with new JAVA code with record locks. All Cobol code runs batch mode. Reads daily transaction file to update files. The new world, Java, will be interactive update...

    Znason460 pointsBadges:
  • Tools for DDS to DDL migration

    Hi, My Profile: I have a legacy DDS defined DB2/400 database and my IT staff are telling me that for true SQL/ODBC access we either need to migrate the database over to DDL defined tables or add unique indexes to the existing DDS structure. My Question: Do we really need to alter the DDS database...

    Newbie4000 pointsBadges:
  • Connect:Direct CDSND command

    Has anybody used this software to send data? We are sending a native file, and were wondering if there was a way to have the file converted to tab delimited on the CDSND command? Or, do we have to tab delimit it to the IFS and CDSND from there ?

    Raddy590 pointsBadges:
  • The server with this database is no longer responding

    I am trying to access a link in a Database on the LNS through the lotus client but it is throwing the error message 'The server with this DB is no longer responding Should notes switch to a replica on other server'. The link is accessible from a other client.I have shutdown the firewall also....

    Prasanna400 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