Stack Overflow
Stack Overflow

Questions tagged [db2-connect]

db2-connect is an independent product used as a database client driver to connect IBM host database servers like zOS and i-Series servers.

db2-connect is an independent product used as a database client driver to connect IBM database servers like zOS, i-Series and Informix. db2-connect package comes with these client drivers: ODBC driver, CLI Driver, JCC Driver, .NET Driver, Python, PHP, Perl and Ruby Driver. It comes with CLPPlus command line tool too.

66 questions
1
vote
1 answer

Problem in establishing DB2 connection in Java with wrong username/password

I have a problem in establishing DB2 connection with wrong user-name/password. We have an application which runs on LAN on many systems using DB2 database located on my system as well as other systems. Firstly I use this URL to create other…
Kishore
  • 41
  • 1
  • 1
  • 6
1
vote
2 answers

Calling stored procedure on i Series using IBM DB2 Connect driver

I have a C# application, from where I am trying to call an ISeries Stored Procedure (wrapping an RPGLE program). This RPGLE program returns a result set back to my C# application. When I try to call the stored procedure, it errors and hangs…
Abhishek Jain
  • 2,957
  • 23
  • 35
1
vote
1 answer

Where will the tablespace be stored?

I am creating a table with tablespace: CREATE TABLE SALARY..... IN ACCOUNTING INDEX IN ACCOUNT_IDX Where will the Accounting and Account_IDX be created?
Aswini
  • 81
  • 1
  • 4
  • 6
1
vote
1 answer

IBM DB2 Control Loop

I am migrating from MS SQL Server to IBM DB2 (Version 9.7). Trying to write a compound SQL While Loop with local variables (Not a part of Stored Procedure), something like - BEGIN ATOMIC DECLARE i INT DEFAULT 12; WHILE i > 0 "DO…
user455580
  • 329
  • 1
  • 4
  • 18
1
vote
0 answers

Invalid character found in a character string argument of the function "DECFLOAT"

This is my query: SELECT GROUP_ACCT.GROUP_ACCT_ID,GROUP_ACCT.GROUP_ACCT_NAME, REMINDER.PAYMENT_REMINDER_TYPE,REMINDER.SEND_DATE FROM CWS.TPR_M_GROUP_ACCT GROUP_ACCT LEFT OUTER JOIN CWS.TPR_TTRN_REMINDER REMINDER ON…
Gaurav Srivastava
  • 11
  • 2
1
vote
1 answer

PHP DB2_Connect issue to AS400 on Windows 7

New job, new department and they do everything on an as/400. Since I know nothing about RPG IV, I'm hoping to use my PHP knowledge to be of use to the team. I'm trying to get PHP to connect to the as/400, here's my code:
user4338354
1
vote
2 answers

Getting DB2 SQL Error while firing a select query using Worklight 6.1.0?

I am trying to connect to DB2 in my local LAN using worklight 6.1.0 and firing a Select Query for lookup of data if exist. But i am getting below error: { "errors": [ "Runtime: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704,…
Pawankumar Dubey
  • 387
  • 1
  • 6
  • 21
1
vote
0 answers

Hebrew character issue in DB2 Connect

I am using DB2 Connect product to catalog the database in AIX server, but the database is in Z/OS environment. When I query the Hebrew character, I am getting the below result. ''É ÉñéßÇâéì 7; Ââ íéäéîÃè áÇâç ßì éè ÇÑéè Çéã éâéÉì èÂ-è ïãçñâá…
Ananth Francis
  • 141
  • 1
  • 4
  • 12
1
vote
0 answers

Connect PHP to AS400 with ODBC or DB2

I'm trying to connect my WEB server to AS400. The web server has not DB2 library neither ODBC library. I have installed XAMPP in my Windows computer, and one of my colleagues also did. He has Client Access on his Computer. We both installed: -…
Perocat
  • 1,481
  • 7
  • 25
  • 48
1
vote
1 answer

How to change default password

We are getting ” IBM DB2 Universal Database Known Default Password Vulnerability” alert in PCI scans. To fix this we should change the DB2 default password. anybody from DBA can help us on this? For more information on this please see…
mithuna kous
  • 309
  • 3
  • 11
0
votes
0 answers

Trying to Connect via JDBC to access a table in mainframe but failing with connection time out / Unsatisfied link error

I am using the same link as url for connectionmanager with user id and pwd that i use for TSO login. but getting wither connection timeout / Unsatisfied link error. db2 driver load is successful but No library path found. Can anyone help me with…
ARNAB BHATTACHARJEE
  • 1
0
votes
1 answer

How to use DB2Connect license file for IBM Db2 .net provider nuget package?

My workstation machine and our app servers(both prod & QA environments) are all got folders C:\Program Files\IBM\SQLLIB\ . It contains DB2 .net providers for older .net framework(C:\Program Files\IBM\SQLLIB\BIN\netf40_32). Our few old applications…
Siva Sankaran
  • 1,521
  • 4
  • 21
  • 40
0
votes
1 answer

Zend Framework using IBM's DB2 and creating a standard connection in the application.ini file

DB2 uses XML files as its basis for database tables, and I have been having a very difficult time finding any good references or examples of creating a standard connection to the database via the application.ini file. There are some examples from…
Sean Hanford
  • 36
  • 2
  • 3
0
votes
1 answer

Unable to modify data on i-Series DB2 from .NET

I am having an application in .NET that uses Entity Framework 4. I am using the DB2/400 as my application backend. I am able to make queries and read successfully from the database. However on any other operation (such as insert/update/delete), I am…
Rajini Kant
  • 1
  • 1
0
votes
1 answer

DB21007E End of file reached while reading the command error

I'm trying to execute the below sql file using db2 in the command line. But Im getting the below error. I'm not sure where it went wrong. "DB21007E End of file reached while reading the command" I'm executing the below sql file using db2 -tvf…
Ravi Kumar
  • 11
  • 5
1
2
3 4 5