• RPGLE Embedded SQL Not null

    RPGLE Embedded SQL is getting a SQL0305 (SQLcid-305, sqlstate 22002) when fetching the next record from a view.  This is pointing to null values encountered.  /free                                                   exec...

    NickHutcheson11,380 pointsBadges:
  • SQL code made simpler

    I have 2 files that are clones - created by DUPOBJ. File_A is the original. File_BU is the copy. After I finish processing File_A, I want to update the same column (tSTAdm) in File_A when it is not equal to the same column (tStAdm) in File_BU. The file has a unique key – TsStat. I got the...

    PSMurray530 pointsBadges:
  • Convert Oracle code to Microsoft SQL code

    I've been given an Oracle DB that has some triggers and "LOAD DATA" jobs. Is there a tool/utility to convert the triggers/loads from PL/SQL into T-SQL?

    VelameLaCosa110 pointsBadges:
  • Oracle Inbound 850 Customer PO’s with Multiple Documents – Odd failure

    Ok, I know I might be sotgunning here, but so far I canna find even a glimmer of an answer to this. Oracle Apps 11.5.9 Oracle eCommerce Gateway Inbound EDI 850 Customer PO's I'm developing this process for a client, and I'm in the middle of testing my solution. Everything works fine when an 850...

    Jwhanon0 pointsBadges:
  • How to save the output from an SQL select statement to a spool file

    Please can someone tell me how I can save the output from an SQL select statement to a spool file. Thanks, Tom

    Tomotsk75 pointsBadges:
  • SELECT with LIMIT in AS/400

    Hi all, On my AS400, I need to select the first 90 records from one file and insert them into another file, but all the time i got all records in my result file. Is there any way to use the parameter LIMIT with my SQL SELECT INSERT INTO LIB1/FILE1 (FILE1) SELECT...

    junioras400250 pointsBadges:
  • How to validate user parameters in Oracle Reports 6i?

    Hi! I am using Oracle reports 6i to modify a standard report. I need to add two user parameters and a field retrieved should be between them if they are not left blank. If they are left blank, then, they should not be taken into consideration. My problem is: These two parameters are included in my...

    Nafy5 pointsBadges:
  • Embedded SQL using SUM or some other method to total up qty and display 1 unique record

    I have an sqlrpgle pgm setup, I want to add another sql select statement. I have a file that contains barcode label data, where multiple records can be assigned to the same Master serial #. My sqlrpg pgm is display various sorts in a screen inquiry. I want to setup my select, to display one record...

    Dobie80 pointsBadges:
  • Modifying a Stored Procedure

    The stored procedure below pulls suspected duplicate records. What I need it to do is return suspected duplicates only if it meets the criteria of having a member record type (GEN) & a non-member record type (WEB). But if the duplicates both have a non-member record type I don't want it showing up...

    DJandLO130 pointsBadges:
  • Writing a “If” & “Then” Statement in Crystal Reports 9

    Hi, I'm new to the site and reletively new to writing code so, please bare with me.  I'm trying to pull duplicate records from a field that has multiple member types {Member_Types.MEMBER_TYPE}. What I want to do is pull only the duplicate records that contain a valid member type. For example 2...

    DJandLO130 pointsBadges:
  • SQL Report Help

    Hi I'm dave and I'm new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return based...

    Blowinup5 pointsBadges:
  • Data Extraction into SQL Server Database from Cache ODBC Database

    Hi.I am trying to extract data from an intersystems cache database into a sql server database for storage and reporting purposes, on behalf of my company. I have not succeeded so far for the last couple of months as it keeps bringing back far more than the expected number of rows, and is...

    SPIDDY0 pointsBadges:
  • Running a script against local SQL servers

    Hi guys i am trying to run a script against local servers stored on a txt file i have already used osql to list the output to a text file. but after this probs

    Cerb300365 pointsBadges:
  • RUNSQLSTM

    am executing a RUNSQLSTM out of a CL program that run a source SQL statement in a source file of a library. Everytime the statement is executed I get a output spool file of the SQL parmeters and execution results. How can I prevent this?

    Abbey120 pointsBadges:
  • How to make the connection in SQL 2000 with Visual Basic 6

    i want to make the sql connection with vb6,how to open the connection in sql

    Vishalngp15 pointsBadges:
  • Embedded SQL in rpg for subfile build SQLCOD

    My fetch next in sql is getting sqlcod = -000000181 and sqlstt = '22007'.  I looked this up.  It says invalid date or time. Pointing to date data types in the file I am trying to read. The records contain two date fields and two time fields. How can I get around this?   Thanks in advance. Nick

    NickHutcheson11,380 pointsBadges:
  • SQL Server Data Files

    I have a production server with 10 databases, is it good practice to put all the log files for all 10 databases on one RAID 5?

    Rick Martinez585 pointsBadges:
  • Frequency of witness pings to partners

    Does anyone know how often the witness instance pings the partners? I am aware of the timeout setting but want to know exactly how often the ping is initiated. Is it the same or different from the timeout value. Thanks in advance for your reply.

    BitBangerDBA5 pointsBadges:
  • Adding a MySQL user when no MySQL users have admin rights?

    I'm working on a MySQL installation that has a user already created ("admin"), but that user doesn't have a password, and doesn't have any permissions, so I can't create new users or even reset the password of that user. I'm using Ubuntu Server, and after looking through the help files I still...

    Michael Morisy8,323 pointsBadges:
  • SQL tutorial?

    Hi , I am having some difficulty in interpretation of SQL questions , I am trying to learn the language self taught is there some interactive tutorial i can try

    Lystra10 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