Questions tagged [Db2] (8)

1
answer

How to put blob (>32k) to a string?

Hello! Task: in database db2 has a table with a column of type BLOB, it maintains data in JSON format, the size can exceed 32K (overflow varchar), these data need to get. ORM - OpenJPA tried casting to the java.sql.Blob, pull out of it an array of bytes, etc, does not work all I have is the class of the object to which thi...
Wilson_Wilderman4 asked March 31st 20 at 14:36
1
answer

How do I output a specific string format using SELECT?

How do I output a specific string format using SELECT? I have a table with data in them are strings with a particular format example : АBC1DE2FJK3. I would like to get all the records in that format. Tried using LiKE'[A-Z][0-9][0-9][A-Z] and so on. Didn't work. Please tell me.
Eric.Block asked March 16th 20 at 14:43
1
answer

Full SQL dump IBM DB2?

The work had to deal with the work of ibm, namely db2 9.7... Question: how to make a full dump of the database in db2, including structure, data, procedures and other logic? like to dump it all to a file, similar in structure to dump the MySQL? db2look only saves the structure, as I understand it. And maybe someone has had ...
joshua_Hills asked October 10th 19 at 10:38
1
answer

Article about DB2

Whether the audience interesting article about some of the features of DB2? Accumulated a certain amount of knowledge as a result of working with him, suddenly someone will be useful.
Dasia_Leffler48 asked October 9th 19 at 17:14
1
answer

DB2. Mapping functions on a Federal basis?

Tell me, please, what am I doing wrong. Trying to call a function from federativnoy base. Connection to database established, the nickname for the user created. Federated database - FDB Working database - RDB On the basis of the FDB created a function:CREATE FUNCTION DB2ADMIN.TEST1 (A BIGINT) RETURNS BIGINT DETERMINISTIC NO...
callie.Muraz asked September 30th 19 at 23:05
0
answer

DB2. Create a function template?

Good morning. I need to create a function template. CREATE FUNCTION DB2ADMIN.MY_FUNCTION( INTEGER, DATE ) RETURNS TABLE ( A DECIMAL(20, 10), B DECIMAL(20, 10) ) AS TEMPLATE DETERMINISTIC NO EXTERNAL ACTION; But DB2 does not do writes SQL0104N An unexpected token "TABLE or ROW" was found following "RETURNS". Expected toke...
callie.Muraz asked September 30th 19 at 22:56
1
answer

How to speed up DB2?

Actually would like to have recommendations for speeding up work with the sql database under DB2-Express. With the database the application runs using a large number of small requests. What points to consider? Explanatory articles are not found... If you need any clarification on application - ask
grayce_Gusikowski58 asked September 26th 19 at 02:25
3
answers

How in sql do a search for names with typos?

You need to search by names of clients allowing, for example, a single typo. There is nothing better than and(1=0 or t.FAMILY like '%Surname%' or t.FAMILY like '%Emilia%' or t.FAMILY like '%File%' or t.FAMILY like '%Faile%' or t.FAMILY like '%Familia%' or t.FAMILY like '%Famiia%' or t.FAMILY like '%of Fami__I%' or ...
orion.Ro asked September 19th 19 at 16:51
2
answers

How to store image files in a web application?

How to store image in a web app written in java? At the moment I have the following principle: a person uploads a photo from the site to the server, the server sends the info to the database and it keeps the path to the image. The image is placed in the WebContent folder. But after recompiling the project, all pictures are ...
reta_Heidenreich20 asked September 9th 19 at 20:53
3
answers

Mainframe developer, last year undergraduate, should I go as the first job?

Studying abroad, need to practice; sent CV to Accenture and then passed a lot of tests and interviews, in the end all went well and I was offered the position Junior Mainframe programmer. Said that they me for six months will teach only from the ground up - IBM Mainframe (z/OS, Cobol, JCL, DB2). Actually this will be my fi...
nikita.Stracke asked June 27th 19 at 10:42
  • 1