• pl/sql fixed file creation

    I am new to the pl/sql world. I'm ok with writing out a comma delimited file but I can't figure out how to write out a file where the fields are fixed length. I could use some examples. thanks,

    Bordenatemple5 pointsBadges:
  • export xml file of new stored data into a folder through trigger in sql server!

    Hello everyone , im newbie on SQL and need to make a trigger that generate an xml file of the new data whenever an action happens ( INSERT ), i looked around and found a clause that can query an output as xml format (FOR XML )but i cant make the actual (xml)file and put it in a path , can someone...

    Rahmony10 pointsBadges:
  • Free SQL software with interface to enter data

    Hi, I need to enter about 5000 lines of data with about 10 columns. and then i would query the data (by lets say sql, but i am open to suggestions). Can anyone recommend a simple freeware to use. My queries would be like ordering the data based on certain column, or getting to view only that data...

    Maqib1005 pointsBadges:
  • Latest date SQL

    Hi I am Trying to grab only the latest date from a uniquie stock number wich has mutiple dates? All i want to show is the lastest date against the stock number. Bear in mind that theese are comming from two different tables. Any Ideas

    Rizdon15 pointsBadges:
  • How to pass array in MySQL procedure parameter

    how to pass array in mysql procedure parameter

    Guptarun5 pointsBadges:
  • select parent where more than one child

    I want to select a row from the parent table based on whether there are two or more rows in a child table. What is the best way to do that?

    Ghjazz5 pointsBadges:
  • Get your FREE ITKnowledgeExchange.com sticker

    Be proud to show off you are part of the community with your free ITKnowledgeExchange.com sticker. All you have to do is answer a question and email me your handle and address and we will get one out in the mail to you. Allow 4-6 weeks delivery. Even if you have one already get one for your...

    ITKE344,900 pointsBadges:
  • Data type for output file in DB2 SQL

    I am using DB2 SQL on the mainframe - not sure of the version - I want to write out a file and transfer it down to the PC - how do I specifiy numeric values for dollar values so that when I bring the file into Microsoft Access the numeric fields come in as numeric and not character?

    Kath95675 pointsBadges:
  • Oracle RR Date Format

    TELL ME ABOUT RR DATE FORMAT IN ORACLE9I(SQL)

    JOGENDER20095 pointsBadges:
  • Can anyone suggest a good loan APR formula in SQL

    I am getting a rather large error with an Excel RATE function, and so am wondering if someone can suggest a SQL formula or a solution?

    Nrate5 pointsBadges:
  • String Aggregate Function

    I need a report that provides an aggregate of a string column - in this case a concatenation of the values in a comma separated string. There is no such DB2 aggregate function that does this. A stored procedure (or possibly a customer aggregate function?) seems the only likely way to accomplish...

    Mgemmill5 pointsBadges:
  • 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:
  • 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:

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