• AS/400 Embedded SQL, RPGLE free format, compilation

    1. My Problem: I am not able to compile a RPGLE free format PGM with embedded SQL. 2. My simple basic code: exec sql select RAGNA from RPFAGE ; *inlr = *on ;  (RPGAGE is the PF name and RAGNA is one of the fields in PF RPGAGE PF contains 100 records) 3, Member type is SQLRPGLE 4. Compile command:...

    anandx625 pointsBadges:
  • How to link Microsoft Excel file in SSMS 2014

    I'm using SSMS 2014 and I'm able to link an Excel file as a linked server. But here's my question: Now I want to link multiple Excel files. Can I link all of the files on a linked server or do I have to do them separately? Meaning one linked server for one Excel file.

    ITKE1,059,635 pointsBadges:
  • SQL query: Get result from row3 and row6 only sometime row1 and 10 only

    PRIMARY KEY (A/C. NO.) ALSO EXISTS IN TABLE2 AND TABLE 3 TABLE1 TABLE2 TABLE3 TABLE3 a/c. no. Consum demand dues 65138546 2500 193 193 65138546 3100 696 696 65138546 3500 700 700 65138546 4000 763 763 65138546 6000 867 867 65138546 7000 1125 1888 65138546 8000 1281 1281 65138546 9000 1594 1594...

    235235235305 pointsBadges:
  • Extract SQL from older unknown Crystal Report .rpt file

    I have an unknown version of Crystal Report .rpt file. I would like to analyze the SQL only - is it reasonably possible to extract the SQL?

    kishjtk5 pointsBadges:
  • What are dynamic and keyset-driven cursors in PL/SQL?

    What's the difference between dynamic and keyset-driven cursors in PL/SQL?

    yethis5 pointsBadges:
  • SQL update a column to remove a certain character

    I have a table (book) where there is a column that contains number in some rows and numbers with an addition *infront. I want to be able to perform some calculation with the table but the '*' is preventing me from doing this. So how do I update or alter the table so that I can remove the * and keep...

    Lazy16755 pointsBadges:
  • SQL: How to take out second maximum salary?

    Is there a SQL Command to find second max salary.

    Rylan08505 pointsBadges:
  • select SQL where data contains a hex value

    I have a file/table with 3 fields. The first field is a batch #, the second field is a record #, and the third field contains data. I need to select from the third field where it contains a hex value of X'0A' which doesn't relate to any character on the keyboard. Can someone show me how to do a...

    Carolh0 pointsBadges:
  • SQL job keeps failing: Access to the path is denied

    I'm not too experienced with SQL so please let me. I have a SQL job that keeps failing. Here's the error message: Access to the path /d$.... is denied. Would this be network related at all? I have it setup so it's going from one server to another server. Any help would be great. Thank you very much.

    ITKE1,059,635 pointsBadges:
  • Using SUBSTR with interactive SQL

    I am trying to change part of a field using the substring command in interactive SQL. To do this I entered the following: UPDATE LIBRARY/FILE_NAME SET SUBSTR(FIELD_NAME1,194,4) = 'XXXXX' WHERE FIELD_NAME2 = 99999 I get the error token ( was not valid. Valid tokens: = .' Obviously there is a syntax...

    GHENDER220 pointsBadges:
  • Retrieve AS/400 user profile list

    How do I code SQL to retrieve user profiles that have not signed on in 60 days?

    KatieEnglish5 pointsBadges:
  • SSRS script when no records found

    I have a script that checks if records are found, if not, return a default row: IF EXISTS ( ' + @SQL1 + ' ) BEGIN ' + @SQL1 + ' END ELSE BEGIN select 0 FIELD1, 0 FIELD2 END The downside to this is it runs the SQL twice. Is there a better solution? I have tried IF @@ROWCOUNT = 0, but that seems to...

    akho9125 pointsBadges:
  • How to create a point geometry in SQL

    Is there a way for me to create a point geometry in SQL?

    kofiankomah5 pointsBadges:
  • Can I perform a DML operation in PL/SQL Functions

    How can I perform a DML operation in PL/SQL Functions

    sameerahmad29055 pointsBadges:
  • SQL Server: The Index Allocation Map Page is Pointed to by the Next Pointer of IAM Page.

    Microsoft SQL Server was running fine until it recently stopped running for no real apparent reason. It's saying: The Index Allocation Map Page is Pointed to by the Next Pointer of IAM Page. Anyone have had similar issue? Your advice is greatly appreciated.

    Frank33115 pointsBadges:
  • Tool for migrating SQL to Oracle

    Hello, Is there a tool that we can use for migrating from SQL to Oracle?

    AhmedKahwaji15 pointsBadges:
  • Display physical file using subfiles in AS/400

    How to display a physical file record using subfiles?

    sampathrsk15 pointsBadges:
  • What SQL career would be good for me?

    I have an Masters degree in accounting and have been working in the field for 30 years. I am interested in learning SQL and want to know what type of career path would make a good fit for me. SQL developer? SQL administrator? (I do not know any other programming languages.) My ultimate goal is to...

    lmcole5 pointsBadges:
  • Where to find SQL Server 2017 Standard edition

    I'm trying to test out SQL Server 2017 Standard edition but can't find it anywhere (don't see a trial). I've already downloaded the Developer edition but it's the same as the Enterprise edition. Can someone point me in the right direction?

    ITKE1,059,635 pointsBadges:
  • How do I pull data from a data set (SQL 10) for specific point in time?

    I need to pull a product ID, unit price and package price for each product, at a specific point in time from a data set. Data set is small, 5 columns, 968 rows. what I need is more specific. I need the unit price at the following points in time: Most days of each quarter; day 45 of each quarter,...

    PaulGraz5 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.

Thanks! We'll email you when relevant content is added and updated.

Following