• Export Oracle data to Excel

    Is there sql code to export data from oracle to excel? I can right click on the data set to export but need to include it as part of the code. Any help would be much appreciated! Thanks

    ITKE346,285 pointsBadges:
  • Inserting 50000 rows using FORALL statement

    How can we insert 50000 rows by using FORALL,please give me entire code?

    Ramesh5530 pointsBadges:
  • Excel report from RPG or SQL

    How do I produce an excel report via RPG or SQL inside an RPG program?

    Taborly0820 pointsBadges:
  • Compare two file data row by row in SQL

    I need to compare two files (Previous data and current data) with same fields but changed in some fields value in Current sheet. I want to compare both files and filter only those records which are changed.  Ex. Previous Data: Reference name Address contact 123A Jhon USA 123 123B Paul UK 457 123C...

    sgautam11110 pointsBadges:
  • What’s the better option for SQL Where clause: IN vs. OR?

    I'm working with my team on several huge databases and we need to know which would be a better option for us in the SQL Where clause: IN vs OR? Is there actually a difference between the two? Thanks so much.

    ITKE346,285 pointsBadges:
  • Migrate SQL .bak file to iSeries

    How do I migrate from an SQL .bak file to the iSeries?

    pgmr85 pointsBadges:
  • SQL convert numeric to date format

    How can I convert an 8 digit numeric (format ccyymmdd) into a real datefield to be used in date arithmetics? I need to calculate the number of months between the month (current date) and a date represented in my DB as an 8 digit numeric with format "ccyymmdd". Therefor (I assume) I need to convert...

    DanTheDane2,555 pointsBadges:
  • Embedded SQL using quotes to build field with wildcard

    How do I set up a cursor in RPGLE to select where a field is LIKE a character field using quotes with a wild card? The character field is a variable declared and built using a field in the program.  I have tried field LIKE :newfield with newfield setup as '%ch%' (single quotes). I tried field...

    cblanch25 pointsBadges:
  • Select number of employees gender wise in each department

    select number of employees gender wise in each department. In the employee table, gender of employees is stored whereas department number is stored in works_on table.

    aamirsuhail25 pointsBadges:
  • Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system?

    We are having an ETL process which inserts lots of data into tables. This database is set to Simple Recovery Model and the transaction log is growing a lot. I was thinking that would it help to set this database into Bulk-Logged Recovery Model? We are taking full backups on daily basis. So is there...

    bugarl5 pointsBadges:
  • I need a formula to map the computed for display item in LEI

    I'm working on a LEI to transfer LN data to SQL. To do this, we have to map the LN fields and SQL columns. Problem here is that LEI does not support computed for display items. These items can be seen in the document properties list so i hope there should be a way to map them in the LEI using the...

    JDJeetya5 pointsBadges:
  • iSeries database update via CL

    Hi! I have an iSeries database table that has a column name JOBQ. I want to update all records with JOBQ value QBATCH into 2 different jobq names for alternate records. I'm a CL programmer and looking for an example of updating a column via SQL that I can call from my CL in a loop.

    SundarNVS5 pointsBadges:
  • What should I do for my career: SQL or NoSQL?

    What should I do for my career: SQL or NoSQL? Please help me...I'm confused on what to do.

    madhanmohan15 pointsBadges:
  • How to remove specific lines from a text files using either vbs or bat.

    We have a text file that is a result of an export from an application we have. We use the following bat file to rename and remove blank lines from it based on the way it exports the export options/format cannot be changed. I would like a way to add to this bat file a method to remove specific lines...

    swinehart68031,050 pointsBadges:
  • What’s \’) in the SQL language?

    What does ') mean in SQL language?

    gracielahoria5 pointsBadges:
  • SQL command to remove number from within a character string

    What is the SQL command to remove a number from within a character string, when the number repeats later in the string? For example, '10PtreeGB-m1 01-01'. I want to remove the 1 after the m, but leave the rest of the characters unchanged (before and after)?

    mskent5 pointsBadges:
  • career advice

    i am a fresh graduate in petroleum engineering and wish to purse a course in sap, I have no experince in IT order than basic computer knowledge.I want a sap course that is related to my field (petroleum Eng) and also make me a consultant.I was looking at MM in sap until recently I met a friend who...

    Haller80 pointsBadges:
  • Debug SQLCBLLE pgm.

    Can anyone please explain the steps involved in the debugging of SQLCBLLE pgm.

    mvrkrishna555 pointsBadges:
  • Documenting column in SQL table in QADBIFLD (AS400)

    When a table is created with SQL, several fields in the system cross-reference file QADBIFLD gets content (headings, defults a.o). I noticed that the QADBIFLD table contains a column named DBIREM (length 2000 bytes..). I also noticed that the old S36 IDDU actually put some documentation into this...

    DanTheDane2,555 pointsBadges:
  • How to keep whitespace in datagrid

    I have a simple .NET app. You key a SQL statement into a text box. It then connects to any one of 5 i-Series and returns a datagrid. I am curious as to how I can preserve the whitespace in the columns. These columns have some fields with data right and left justified. Other fields a large field...

    ToddN200011,190 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