• Using SRCDBG with an SQLRPGLE module

    I'm trying to debug a RPGLE module created with CRTSQLRPGI. The STRDBG program returns an error message stating the program "cannot be accessed". There is no DBGVIEW option on the CRTSQLRPGI command, so even if I get the debug to work. will I see any source data? Thanks.

    Grp5 pointsBadges:
  • file user open exceptions for printer file

    i'm opening a program defined printer file in SQLRPGLE.. i get error file is already open.... if that is the case, then i'm trying to write in that file but now this gives me exception that attempting to write in closed file...   Please help

    Nutangujar895 pointsBadges:
  • Need to know the date and time a particular sql command was fired through an interactive session

    Is it possible to find the date and time a particular sql command was entered. Iam able to view the commands entered in an sql session but not able to find the date and time the commands where fired.

    JohnsonMumbai1,160 pointsBadges:
  • Can I Use Tomcate as a “Witness” Server in SQL 2005 Mirroring

    Hello i am using SQL 2005 and i have Tomcat as an Application Server i want to use Mirroring on my DB and i am looking for the way that let me make Tomcat as my Witness server [Br class="height5" />[small] [/small]

    ITKE352,580 pointsBadges:
  • SQL EXPLAIN

    How do I interpret the EXPLAIN plan of a particular SQL which has "Bytes" and "Cost(CPU%)" columns?

    ITKE352,580 pointsBadges:
  • SQL Communication Area

    Hello, Can anyone explain the fucntionality of the program QSYS/QSQROUTE in AS400. Thnaks in advance

    Sris198655 pointsBadges:
  • SAP on SQL Server and NetApp

    Hi Everyone, We are looking for some feedback from anyone who has used NetApp with SAP running on a SQL database. We are researching white papers, etc., but would really like to hear from some folks with hands on experience. What has your experience been like? Any performance hits? Any caveats or...

    DebDonohoe5 pointsBadges:
  • sap training

    where is a good place to start to take sap training?

    Tsscare5 pointsBadges:
  • Cal I load a record SET into a work file using SQL within RPGLE?

    ALL - I have to process a set of Inventory Transactions based on W/H, Product, From Date, and To Date. Normally, I would jump into a Do Loop; read the SQL cursor; write the record to a work file; process until EOF. Can an SQL statement do all of that for me in one statement? I have not been able to...

    MurrayInfoSys940 pointsBadges:
  • General ODBC Error – Why

    I get an gernal ODBC error when running the below code. It looks like the sqlt is too long, but how can I get it to work as I need the query to be dynamic based on date. sqlt = "SELECT SCHED_TASK_EXEC.TASK_ID, SCHED_TASK_EXEC.TASK_TYPE, SCHED_TASK_EXEC.EXEC_TIME, SCHED_TASK_EXEC.END_TIME,...

    ITKE352,580 pointsBadges:
  • SQL Query Issues with date math

    Table with partial sample data would appear as follows: EQUIPNO  ASSEMBLY  START_TIME  END_TIME 150          0              24-MAY-09   25-MAY-09 150          0              25-MAY-09   25-MAY-09 150          0             ...

    Phoenix210 pointsBadges:
  • sql .net 2005 deployment

    I am trying to connect my desktop application to sql server on a lan  but the clients are being recognised as guest how do i enable ny appplication to run on the lan. I am using windows authentication.  

    Semauel8515 pointsBadges:
  • How to remove duplicate row in multi joined table?

    My qurey is below. SELECT [5000Phantoms79w/VNos&othersFromAna].ID, [5000Phantoms79w/VNos&othersFromAna].PhtomNo, [5000Phantoms79w/VNos&othersFromAna].[New No], [5000Phantoms79w/VNos&othersFromAna].[dB OE tied to Phantom], [5000Phantoms79w/VNos&othersFromAna].dB2ndSetNewNo,...

    CompEng1,240 pointsBadges:
  • Upload a table to Mainframe

    How can I upload a SQL table to mainframe dataset? I want to know the proper syntax of how can i upload a table to Mainframe using FTP

    KarishmaKapoor20 pointsBadges:
  • monthly labour accruals in ECC6

    how are the monthly labour accruals calculated in ECC6 when then pay date in the beginning of the month ie 1 Ocotber 09

    Maritime10 pointsBadges:
  • sql update command to update a date-of-birth

    I need to change the date-of-birth MONTH to May and DAYS to 15 without changing the YEAR

    Mji50 pointsBadges:
  • sql update command to change text

    I need to modify all characters within a text field. Some of the fields will contain 2-5 characters, others will contain 20-200 or more. The field is defined as Text 4000. I want to replace every letter with "K" We have a Select statement: select...

    Mji50 pointsBadges:
  • Is it possible convert a mainframe COBOL program to read DB2 data on the mainframe and Oracle data on a server?

    I have a mainframe batch COBOL program that reads DB2 data. One of the tables is accessed via a singleton SELECT. The table is being moved to an Oracle database on a Unix server. How do I change the program to be able to access the data in Oracle? Are there different ways to it? I'm assuming there...

    Srichfdic20 pointsBadges:
  • DB2 Select on a large number of rows/

    I have to run a DB2 against a number of table for example tableA, tableB and select a number of fields from the table. However, I have to run the selection against 5,000 records that. I want to know if using SQL embedded in a JCL, if I could plug in a file with the records I want to select for...

    Michaelf215 pointsBadges:
  • Defining a sort variable (ORDER by) in RPG SQL

    I have a file that I would like to sort on a specific column that a user would choose. I sort the file by an imbedded SQL statement: ORDER by PRDNO. Works fine. If I try and make it a variable (ORDER by :Sort_Seq), the statement is ignored. Is there a way to make the ORDER by a variable in RPG SQL?...

    MurrayInfoSys940 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