皇冠hg0088代理网址

Questions tagged [db2]

DB2 is a family of database servers developed by IBM. Supported platforms for DB2 servers are z/OS (formerly OS/390), Linux, UNIX, and Windows (referred to collectively as DB2 for LUW), and IBM i (formerly OS/400 or i5/OS). Originally designed as a relational engine, IBM has expanded DB2's capabilities on some platforms to include native XML support and an RDF-compliant graph store. When posting DB2 questions, please specify the platform and version.

Filter by
Sorted by
Tagged with
0
votes
1answer
27 views

Extract domain from a link in Python and using SQL

I have a database to which I am connecting to using Python and running the sql statements in the following way . import ibm_db conn = ibm_db.connect("DATABASE=ABCD;HOSTNAME=dsomehostname.net;PORT=...
0
votes
1answer
22 views

Issues connecting to Db2 from Jupyter Notebook

dsn_driver = "{IBM DB2 ODBC DRIVER}" dsn_database = "BLUDB" # e.g. "BLUDB" dsn_port = "50000" # e.g. "50000" dsn_protocol = &...
0
votes
0answers
6 views

Importing Multiple tables at same hdfs location using sqoop

Is there any way to import multiple tables at a single HDFS location using sqoop.I Have 5 tables in db2 schema(tab1,tab2,tab3,tab4,tab5),and one hdfs location /user/hive/db2_tables. I want to store ...
-1
votes
2answers
18 views

Installed IBM DB2 and created sample database. Database has been created but not able to see any tables in it

Sample database was created but got a glitch while creating and now iam not able to see the tables. How to deleted or drop the db and create a new sample db.
0
votes
0answers
16 views

Sqoop Importing Data with header from db2

Is there any option in Sqoop to import data with a header from db2? I am importing data from db2 and saving at hdfs location with pipe '|' delimiter, but it's not importing the header from the db2 ...
0
votes
0answers
15 views

Run DB2 Query on Visual Studio with “|” in query?

I have DB2 query where inside I have to concacte with "|" to get the result. Here's the query : SELECT DISTINCT npkdcb, npkdps, npcob, npureg, ...
0
votes
0answers
23 views

After upgrade from Db2 v9.7 to v11.1, USEREXIT is failing with adm1833e and error code 28

IBM doc says it means "Error caused by an input/output (I/O) failure, or by the operating system" Config is set correctly. We do have sqllib/adm/db2uext2 with permission of -rwxr-xr-x from ...
1
vote
1answer
23 views

Scalar function NLV2 not found on DB2 9.7

I'm using DB2 V9.7.11. I found scalar function NVL2 in IBM official documentation for db2 LUW, which version is 9.7. But when I used this function in my sql statement, it returned: No authorized ...
0
votes
1answer
25 views

How do I parameterize limit?

I cannot bind the limit parameters in my statement. How can I accomplish this? import ibm_db conn = ibm_db.connect("") sql = "SELECT * FROM my.table where id = ? limit ?, 100" ...
0
votes
1answer
27 views

I am getting following Error message while creating IBM db2 procedure

What is wrong with the following code? PROCEDURE DATETYPE DYNAMIC RESULT SETS 1 LANGUAGE SQL BEGIN DECLARE @DateType TABLE ( LABEL CHAR(30) , Value VARCHAR(1) ); DECLARE C CURSOR WITH RETURN ...
1
vote
0answers
17 views

Setting library list using IBM.EntityFrameworkCore

I read in the docs that you must set the SystemNaming property to true to use the library list attribute in the connection string. I don't see a way to do that using IBM.EntityFrameworkCore. In ...
0
votes
0answers
47 views

Having trouble connecting to iSeries from .NET Core

This is a follow-up from the following question: Having trouble connecting to iSeries from .NET Core The initial problem was resolved by setting a port number. I'm now running into the problem of the ...
0
votes
0answers
35 views

Target table empty when migrating DB2 to SQL Server using SSMA [closed]

I have done followed the steps: connect to DB2 connect to SQL Server create report convert schema synchronize (and load?) After this point I see the table in SQL Server, so synchronization was ...
0
votes
0answers
21 views

EF Core IBM Db2 Specified cast is not valid for Bool type

I have already asked it in ef core github, and not sure where to ask for help. but I am using IBM Db2, and experiencing an error of a bool type attribute $ curl -XGET http://localhost:5005/bills/get -...
0
votes
0answers
41 views

What is the definition of a Driving Cursor in SQL?

I started in a project involving Cobol and DB2 on an IBM z/OS host system. The software module documentation makes frequent references to a term called "driving cursor". Could someone ...

15 30 50 per page
1
2 3 4 5
722