• DB2 User Password creation

    Hi, I am new with this database administration. I have installed DB2 Express C.Now I want to create a user & to assign password for this user through Data studio. I can create an user, but unable to assign the pwd. Please let me how to assign the password for an user created through data studio.

    HABBIE805 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:
  • Null dates coming in as 2001-01-01 SQLRPGLE

    Our SQL statement is literally trying to put '0001-01-01' into a field and it's still coming back as 2001-01-01... Any ideas?

    Dcantwell470 pointsBadges:
  • Sending email attachment from mainframe – MIME format

    Hi, I need to email 2 flat files from mainframe as CSV files. (the data in the flat files already contains the delimiter ','). The problem is, i get the 2 files attachements as CSV, but nothing in them! I feel I've got the MIME formatting wrong. I use IEBGENER, and the flat files are FB format....

    Dannymit0 pointsBadges:
  • SQL to go From N Rows to 1 Row and N Columns

    I would like to ask for your help one more time, if you may. I work for an insurance company and am facing a challenge. I have two tables as such: policy_table Policy_number 12345 98765 45678 Policy_id (PK) 1 2 3 endorsement_table Endorsement flood quake theft hurricane freeze-pipe fire dog-bite...

    Esdras25 pointsBadges:
  • How to export query output from qmf to access and/or excel?

    I would like to be able to use the date eventually in excel? Is there a way to export direct to excel? If not, through access is another option. How do I accomplish these?

    mtanutama10 pointsBadges:
  • DB2 Web Query Access

    Hi Group! I have installed the DB2 web query and configured it and it was working well. For example http://XXX.XXX.XXX.XXX:11331/webquery/i5-loginf In this port number I used to access the db2 web query in my browser. For the recent times I did not used this web query and I have shut down our...

    Sureyz2,375 pointsBadges:
  • Qmf for Windows 8.1 fp18 – date datatype from db2 z/os 8 format error in excel 2003

    When I import a DB2 z/OS query resultĀ  containing date or date(timestamp) columns from QMF for WINDOWS in EXCEL 2003 using the Add-in the cells cannot be formatted. In the same column the date are displayed sometimes as dd/mm/yyyy, sometimes as nnnnn or in the previously defined format (example...

    Erredi5 pointsBadges:
  • Create DB2 table relations

    There is a requirement to have a subset of data available in DB2 tables in production to a test environment. There is no relationship defined in DB2 (so info available in catalog relationship tables). Now we need to find the relationship between the tables using some automation process. So we might...

    Toramky5 pointsBadges:
  • SQL / DB2 Optimization (timing out)

    I put together a simple VB program to run SQL commands on any of our 4 I-series machines to return a simple grid view. I have run across a strange problem and was told it may have to do with optimization. For example if I run the following SQL ( I just want a count of parts (pm) that have not been...

    ToddN20008,300 pointsBadges:
  • Having issues connecting DB2 with .NET

    I'm trying to connect to a DB2 database (an iSeries version) using .NET by referencing a .DLL and not installing software on my server. I currently have IBM.Data.DB2.iSeries.dll installed as part of iSeries access for Windows. Is there an easy way to connect from .NET to DB2 by referencing a .DLL...

    ITKE342,195 pointsBadges:
  • Is the new WRKDBF out yet?

    Anyone heard if the efforts to recreate a WRKDBF utility have borne fruit yet? Once again I find myself needing a general purpose file view utility, and hover on the brink of writing something, for I saw somewhere that a new one was being put together.

    Yorkshireman5,580 pointsBadges:
  • Need some help with queries in DB2

    Members on our team have a massive database that's housed in DB2 for i server that they are accessing through SQL Explorer. But the tables aren't very well documented and they're trying to do a few things with it.Search the entire database that look for tables with a column called "Remarks"Search...

    ITKE342,195 pointsBadges:
  • I’m having trouble with a simple query in DB2 for AS/400

    I know I'm an amateur when it comes to AS/400. I have this "easy" query but I still can't do it. Here's what I have:A B C 1 1100 5 1 1100 5 1 500 1 2 1200 4 2 1200 4 2 600 1 3 1300 3 3 1300 3 3 700 1And this is how I want it returned:A B C 1 1100 10 2 1200 8 3 1300 6I tried this but it's only...

    ITKE342,195 pointsBadges:
  • how to set gridview column width to auto

    I put together a simple vb program, or so I thought. I am accessing DB2 tables and trying to pull the data in using a DB2 reader. What I'd like is to have the columns be set to width=auto. The number of columns depends on the DB2 table. I'm getting an error "Index was out of range. Must be...

    ToddN20008,300 pointsBadges:
  • iSeries: Text fields from different records in same file

    We have some data (in a file of course) on iSeries using DB2. Here's the file structure:Item Textline Text 12755 1 this item 12755 2 is no longer 12755 3 for sale abc123 1 please use abc123 2 another code xyz987 1 obsoleteThis is the result that we're trying to get: Item Text 12755 this item is no...

    ITKE342,195 pointsBadges:
  • What’s wrong with my following code for connection to a DB2 database?

    I'm trying to connect to a DB2 database with PHP. I have a code but it's not really doing anything for me. It's not returning an error message but just breaks JavaScript later in the page. Here's the code:include(TEMPLATEPATH.'/inc/library/adodb_lite/adodb.inc.php'); $DBName = 'DBNAME'; $Host =...

    ITKE342,195 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...

    ITKE342,195 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...

    ITKE342,195 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!

    ITKE342,195 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