• IMPORT OR EXCEL DATA INTO ORACLE FORMS 6I

    Hi all, i have to import excel data of two column into oralce forms 6 i on button pressed trigger.can any one help me in this regard with source code.thanks a lot in advance

    ZOMGPS5 pointsBadges:
  • Easy and faster way to pull data from a server using ODBC (VBA)

    I am looking for couple of options to pull data from AS/400-ODBC connection and manage data in Excel.

    xxsinghxx20 pointsBadges:
  • DB2/iSeries clean up

    I'm trying to find and clean up line breaks, carriage returns, tabs and "SUB"-characters in a set of 400k string records but I'm having a ton of trouble with my DB2 environment.After doing some searching, and I thought replacing with the "REPLACE()" and "CHR()" functions could work, but it's not...

    ITKE352,565 pointsBadges:
  • Having difficultly making my DB2 queries case sensitive

    I'm been having a lot of problems making my DB2 (AS/400) queries case sensitive. Here's an example of what I'm trying to do: SELECT * FROM NameTable WHERE LastName = 'smith' That returns zero results but this returns 1000's or results: SELECT * FROM NameTable WHERE LastName = 'Smith' Does anyone...

    ITKE352,565 pointsBadges:
  • Looking to add a column to DB2/400 table

    I'm a beginner with AS/400 and I'm wondering if there's an SQL command on AS/400 to add a column to a table in a specific ordinal position (or moving an existing column to a different position)? Pointing me in the right direction would be great. Thanks!

    ITKE352,565 pointsBadges:
  • Can I select the identity value from an insert statement?

    Our company is using iSeries for DB2/AS400 and we're hoping someone can help us with this simple question. Would there be a way to return the identity value from an insert statement without using two lines of SQL? We're currently being forced to use inline SQL in C# to perform an insert. Basically,...

    ITKE352,565 pointsBadges:
  • Trying to call a DB2 stored procedure in IBM System i Access

    I'm trying to test a DB2 stored procedure that's running on an AS/400 system. Our company currently has the IBM System i Access for Windows installed that runs SQL commands against the DB2 database. My big question: What is the syntax to execute a stored procedure that takes in a parameter /...

    ITKE352,565 pointsBadges:
  • Mailbox Access Rights

    On Exchange 2010, how can I generate report for users’ mailbox access permissions?

    darrence5 pointsBadges:
  • I need help creating a delimitted string in DB2

    Over the past few days, I've been trying to create a delimited string from the results of a query in DB2 on iSeries. I was able to do it in T-SQL but am struggling here.Here's the code I used in T-SQL. I'm basically looking for the equivalent in DB2.DECLARE @a VARCHAR(1000) SELECT @a = COALESCE(@a...

    ITKE352,565 pointsBadges:
  • Scheduling join queries in AS/400

    I have an AS/400 join query that runs across 5 tables. I need to get it to run programmatically via scheduled CL scripts. I'm trying to make it work using RUNQRY, but that only shows the query itself, not the results. How can I make this work?

    ITKE352,565 pointsBadges:
  • Access Database

    Access Database Question. I have two databases: Company and project. I want to be able to input a primary and secondary description of the work at the project level that is saved at the project level, but also adds to the company database (if that primary and/or secondary description hasn't already...

    bruceinpl5 pointsBadges:
  • We’re looking to add a field description in a DB2/400 file

    My partner and I have a set of files on an AS/400 system but we don't have DDS for (the files were created in SQL). We would like to add field descriptions but we're struggling to find how to do this in AS/400.Could someone tell me how we can add a field description? Is directly updating...

    ITKE352,565 pointsBadges:
  • CASE keyword statement in DB2 for IBM iSeries

    I've been recently writing queries for DB2 on an IBM iSeries box. I know about the "CASE" keyword, but it's not working for me. I keep receiving this error message: Keyword CASE not expected. Here's one of my sample code: IF EXISTS ( SELECT * FROM MYTABLE WHERE KEY = xxx ) THEN UPDATE MYTABLE SET...

    ITKE352,565 pointsBadges:
  • Debugging stored procedures for DB2

    Is there a tool for IBM DB2 similar to PL/SQL Developer where I can develop a debug stored procedures?

    ITKE352,565 pointsBadges:
  • AS/400: ODBC call continues to hang

    My Uncle is using C# .NET ODBC connection to try to retrieve data from an iSeries (AS/400) database. From what he tells me, if the files and procedures are not promoted properly on the iSeries side, ODBC should call a level check error. Unfortunately, it appears the handshake between the ODBC...

    ITKE352,565 pointsBadges:
  • Cleaning up code in DB2

    I have a major project wherein I have to clean up some 500k string records in a DB2 environment. This entails removing line breaks, tabs, stray code, etc. Unfortunately, I'm not as familiar with DB2 as I thought. I tried to use REPLACE() and CHR() functions, but CHR() does not work: (Error: CHR in...

    ITKE352,565 pointsBadges:
  • AS/400 and DB2: Pagination query

    I'm currently working on a project in which I'm trying to create PHP web-based paging for our tables that have over a million rows. I've figured out that I have three options:Retrieve all rows in resultset (Not possible due to the size)Retrieve 1,000 rows, put in temporary table and create an...

    ITKE352,565 pointsBadges:
  • RPG programming: Are nulls not permitted?

    I know this might be an off-topic discussion but I was recently told by one of our RPG programmers that none of our AS/400-based DB2 database tables can permit nulls because "they're really difficult to program" for in RPG. Is this true? If so, what makes the basic database feature so difficult in...

    ITKE352,565 pointsBadges:
  • Receiving error message in DB2/400 drop column

    I'm looking to drop a column, known as "id", which would auto incrementing PK. Here's the SQL:alter table "CO88GT"."XGLCTL" drop column id cascade;And I've been this error:Error: [SQL0952] Processing of the SQL statement ended. Reason code 10. SQLState: 57014 ErrorCode: -952I'm not sure but it...

    ITKE352,565 pointsBadges:
  • Free IT Book: AAA Identity Management Security

    This week's free IT book is your complete, authoritative guide to implementing, configuring, and managing AAA with CiscoSecure ACS. For a chance to win AAA Identity Management Security, answer one of the questions listed below and post the link to your answer in the discussion section of this...

    MelanieYarbrough6,345 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