Ошибка sql error code 104 - ErrorsMaster.ru - большая энциклопедия ошибок и их решений

I am executing an SQL query via jcc to run a report. When I opened the error log file for the program and examined the SQL query, everything seems to be fine (There are no extra or missing brackets, commas, etc and the syntax is good) however when I execute I am getting this error:

[Report.execute()] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=,;ATE IN (1,2,3,10,1)
;, DRIVER=4.12.55

When I researched about the SQLCODE I found out that it means there is an illegal symbol in the query. What can I look for to find this illegal symbol?

This is the query

Sorry for the tiny font but if you zoom 200% or so you can see the query better.

Thanks a lot

Источник

The SQL error sqlcode=-104 sqlstate=42601 is a syntax error that occurs in DB2 databases. It indicates that the SQL statement is not properly formed and could not be executed by the database server. This error can occur for a variety of reasons, including incorrect use of quotation marks, missing keywords, or incorrect syntax.

Method 1: Check Quotation Marks

To fix the DB2 SQL error sqlcode=-104 sqlstate=42601, you can use the «Check Quotation Marks» method. This error occurs when there is a syntax error in the SQL statement. Here is an example of how to use the «Check Quotation Marks» method:

Check the SQL statement for any missing or extra quotation marks.

SELECT * FROM table WHERE column = 'value

In this example, there is a missing quotation mark at the end of the value.

Add the missing quotation mark to the SQL statement.

SELECT * FROM table WHERE column = 'value'

Now the SQL statement is correct and the error should be fixed.

Here is another example:

Check the SQL statement for any missing or extra quotation marks.

INSERT INTO table (column1, column2) VALUES ('value1, 'value2')

In this example, there is a missing quotation mark after value1 and an extra quotation mark after value2.

Add the missing quotation mark and remove the extra quotation mark from the SQL statement.

INSERT INTO table (column1, column2) VALUES ('value1', 'value2')

Now the SQL statement is correct and the error should be fixed.

By using the «Check Quotation Marks» method, you can easily fix the DB2 SQL error sqlcode=-104 sqlstate=42601. Just make sure to check your SQL statement for any missing or extra quotation marks.

Method 2: Verify Keywords and Syntax

To fix the DB2 SQL error sqlcode=-104 sqlstate=42601 using Verify Keywords and Syntax, follow these steps:

Open the SQL query that is causing the error.
Identify the line number where the error occurred.
Verify the syntax and keywords used in the SQL query.
Make sure that all keywords are spelled correctly and that there are no typos.
Check that all parentheses and quotation marks are properly closed.
Verify that all table and column names are correct and exist in the database.
Check that all data types and functions are used correctly.

Here are some examples of how to use Verify Keywords and Syntax to fix the DB2 SQL error sqlcode=-104 sqlstate=42601:

Example 1:

SELECT * FROM employees WHERE salary > 5000 AND department = 'Sales;

Error: DB2 SQL error sqlcode=-104 sqlstate=42601

Solution:

SELECT * FROM employees WHERE salary > 5000 AND department = 'Sales';

Explanation: The error was caused by a missing quotation mark at the end of the string ‘Sales’. The corrected query includes the missing quotation mark.

Example 2:

UPDATE employees SET salary = 6000 WHERE employee_id = 1234;

Error: DB2 SQL error sqlcode=-104 sqlstate=42601

Solution:

UPDATE employees SET salary = 6000 WHERE employee_id = '1234';

Explanation: The error was caused by using the wrong data type for the employee_id column. The corrected query includes quotes around the value to indicate that it is a string.

Example 3:

SELECT first_name, last_name, salary FROM employees WHERE salary > 5000 ORDER BY last_name DESC;

Error: DB2 SQL error sqlcode=-104 sqlstate=42601

Solution:

SELECT first_name, last_name, salary FROM employees WHERE salary > 5000 ORDER BY last_name DESC;

Explanation: The error was caused by a missing comma between the last_name and salary columns in the SELECT statement. The corrected query includes the missing comma.

By following these steps and using Verify Keywords and Syntax, you can easily fix the DB2 SQL error sqlcode=-104 sqlstate=42601 and ensure that your SQL queries are error-free.

To fix the DB2 SQL error with SQLCODE=-104 and SQLSTATE=42601, you can use trusted tools and debugging techniques. Here are the steps to follow:

Identify the cause of the error. The error code indicates a syntax error in the SQL statement. Check the SQL statement for any syntax errors such as missing or incorrect keywords, incorrect use of operators, or missing or incorrect punctuation.
Use a trusted SQL editor or IDE to write and test SQL statements. These tools typically have syntax highlighting and error checking features that can help you identify and fix syntax errors.
Use the DB2 command line processor (CLP) to execute the SQL statement. The CLP provides debugging options that can help you identify and fix errors. For example, you can use the «-z» option to enable tracing, which will generate a trace file that can help you identify the cause of the error.
Use the DB2 Control Center or IBM Data Studio to debug the SQL statement. These tools provide graphical interfaces that allow you to step through the SQL statement and view the values of variables and expressions.

Here is an example SQL statement with a syntax error:

The error is caused by the misspelling of the keyword «FROM». To fix the error, change «FORM» to «FROM»:

In conclusion, using trusted tools and debugging techniques can help you quickly identify and fix syntax errors in SQL statements. Remember to test your SQL statements thoroughly before executing them in a production environment.

Method 4: Consult the DB2 Documentation

To fix the DB2 SQL error sqlcode=-104 sqlstate=42601, you can consult the DB2 documentation for more information. Here are the steps to do it:

Go to the IBM DB2 documentation website.
Look for the SQL error codes section.
Search for the error code sqlcode=-104 sqlstate=42601.
Read the description and possible causes of the error.
Look for the suggested solutions to fix the error.

Here are some sample code examples that you can use to fix the error:

Check the syntax of your SQL statement:

SELECT * FROM mytable WHERE name = 'John'

Use double quotes instead of single quotes for identifiers:

SELECT "name" FROM mytable

Use the correct data type for your values:

INSERT INTO mytable (id, name, age) VALUES (1, 'John', 30)

Use the correct syntax for your SQL function:

SELECT COUNT(*) FROM mytable

In conclusion, consulting the DB2 documentation can provide helpful information and solutions for fixing SQL errors. By following the steps outlined above and utilizing the provided code examples, you can successfully address the DB2 SQL error sqlcode=-104 sqlstate=42601.

Источник

Pavel181818

0 / 0 / 0

Регистрация: 15.07.2009

Сообщений: 6

21.07.2009, 11:26. Показов 14676. Ответов 3

Метки нет (Все метки)

Мне нужно создать таблицу в InterBase. Пишу следующий запрос:

T-SQL

CREATE TABLE TABL1 (
Kod INTEGER IS NOT NULL,
Object CHAR(100),
№_dogovora_data CHAR(70),
Zakazchik CHAR(50),
Sroki CHAR(40),
Istochnik_phinansirovania CHAR(50),
Srtoim_v_bazovih_cenah NUMERIC(50,0),
Stoim_v_tekuchih_cenah NUMERIC(50,0),
Stoim_indeks_rosta_cen NUMERIC(50,0),
PRIMARY KEY (Kod)
);
COMMIT;

Выдаёт ошибку:
Dynamic SQL Error
SQL error code = -104
Unexpected end of command…
Помогите найти ошибку.
И ещё такой вопрос: можно ли чтобы заголовки столбцов были написаны русскими буквами?

Programming Эксперт 94731 / 64177 / 26122 Регистрация: 12.04.2006 Сообщений: 116,782	21.07.2009, 11:26
3

АНК

125 / 116 / 17

Регистрация: 27.02.2007

Сообщений: 291

02.09.2009, 10:20

Я посмотрел в IBExpert’е, что за ошибка возникла. Получил вот это:

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown — line 2, char 11.
IS.

тут по-моему все ясно.

Корилические символы в заголовках применять нельзя
У типа NUMERIC длина больше 18 не бывает
Зарезервированные слова (типа «OBJECT») применять нельзя
И в результате:

T-SQL

CREATE TABLE TABL1 (
Kod INTEGER NOT NULL,
OBJ_ECT CHAR(100),
NUM_dogovora_data CHAR(70),
Zakazchik CHAR(50),
Sroki CHAR(40),
Istochnik_phinansirovania CHAR(50),
Srtoim_v_bazovih_cenah NUMERIC(18,0),
Stoim_v_tekuchih_cenah NUMERIC(18,0),
Stoim_indeks_rosta_cen NUMERIC(18,0),
PRIMARY KEY (Kod)
)

0 / 0 / 0

Регистрация: 15.07.2009

Сообщений: 6

02.09.2009, 10:25

[ТС]

Я уже давно исправил эти ошибки, но всё равно спасибо

0 / 0 / 0

Регистрация: 08.04.2015

Сообщений: 13

24.11.2009, 08:46

Сообщение от Pavel181818

Я уже давно исправил эти ошибки, но всё равно спасибо

И в чем была ошибка? В этом «OBJ_ECT» что ли?Подскажите пожалуйста.

Источник

Содержание

Error -104 creating Firebird stored procedure
1 Answer 1
Problems executing SQL-script using Firebird.NET 2.5 (Error Code = -104)
2 Answers 2
Firebird SQL: error code -104, token unknown
1 Answer 1
Sql error code 104 firebird что значит
Sql error code 104 firebird что значит

Error -104 creating Firebird stored procedure

I cannot run the following SP

The error I get is the following:

1 Answer 1

Have you used Set Term before and after this code?

All commands in Firebird must be terminated with a semi-colon. If you want to create a stored procedure you need to be able to distinguish between the terminating semi-colon from the semi-colons inside the stored procedure.

Something like this:

Please notice how the declaration of the stored procedure is terminated with ^, thus ending the statement. After the declaration you also restore the terminating semi-colon.

On a side note, I would recommend to copy firebird.msg to the location the error you get tells you so you can see what is really happening.

EDIT:

If you wish you can check this link. There you can find a lot of information regarding Firebird + IBExpress, including SET TERM (page 81).

EDIT 2:

Just tried at home with IBExperts + Firebird and I had no problem creating the stored procedure. My guess is you are trying to do one of the following things:

You have opened an SQL editor and are trying to compile the code directly. That will not work because IBExperts thinks you are trying to run DSQL sentences. Stored procedures are created with PSQL sentences.

You are trying to use the «New procedure» utility (check buttons in the upper right side of the main menu) and pasted the whole code into the editor. That will not work because in that editor you only have to put the body code. Stored procedure name is set in a field on the upper right side of the window you opened. Parameters and variables are introduced by using the «Insert Parameter/Variable» button on the left side above the code editor. The SET TERM sentences are created automatically by IBExperts. You can check the resulting code in the DDL tab.

Источник

Problems executing SQL-script using Firebird.NET 2.5 (Error Code = -104)

Sorry for my English first of all. I have a problem and need help. I have a simple tool made by myself on c#. This tool makes connect to local or remote firebird server (v.2.5). And my tool can create specified .fdb file (database) somewhere on the server.

Also I have a file with SQL statements (create table, triggers and so on). I want to execute this file after database was created. Executing this file will fill structure of user database — not data, only structure.

But then I try to execute my SQL script — firebird server returns a

SQL error code = -104 Token unknown line xxx column xxx.

That’s the line on this CREATE TABLE SQL statement, for example:

If I will leave only one create statement in my file — all will be good. I don’t know how I explained (it’s clear or not)) — another words — why can’t I execute full query with many create statements in one transaction? There is my main method which executes query:

There is a query is my SQL file.

2 Answers 2

As Victor already stated in his final comment, you can use the FBScript class for batch execution.

I was just confronted with the same task. This question pointed me in the right direction but i had to do some further digging.

I this example, the source of the statements is a external script file:

This will work fine, but you may wonder why this whole thing isn’t surrounded by a transaction. Actually there is no support to «bind» FbBatchExecution to a transaction directly.

The first thing i tried was this (will not work)

This will result in an exception stating: «Execute requires the Command object to have a Transaction object when the Connection object assigned to the command is in a pending local transaction. The Transaction property of the Command has not been initialized.»

This means nothing more than that the commands that are executed by FbBatchExecution are not assigned to our local transaction that is surrounding the code block. What helps here is that that FbBatchExecution provides the event CommandExecuting where we can intercept every command and assign our local transaction like this:

Note that i have uncommented the myTransaction.Commit() line. I was a little bit surprised by this behavior, but if you keep that line the transaction will throw an exception stating that it has already been committed. The bool parameter fbe.Execute(true) is named «autoCommit», but changing this to false seems to have no effect.

I would like some feedback if you see any potential issues with assigning the local transaction this way, or if it has any benefits at all or could as well be omitted.

Источник

Firebird SQL: error code -104, token unknown

I have a script, below, in Ostendo (an ERP), which runs on a firebird database. The script is written in Pascal. It returns an error «Firebird SQL: error code -104, token unknown, ’13/04/2018′ at the line TMPQuery2.ExecQuery. I removed the reference text DATEWORKED = AND and it works fine. I have commented out all the other lines I tried in solving it — of which none worked.

Any ideas as to where I am going wrong? I have a feeling it is do to with date format. I have tried dd-mm-yyyy, yyyy-mm-dd (which is how it works from a OBDC through excel), dd/mm/yyyy (which is how it is displayed in ostendo).

1 Answer 1

From where did you get the idea that date literal in Firebird is represented in format like ? The legal formats to cast string data types to the DATE is listed at «Literal Formats» section in the «Conversion of Data Types» chapter.

Basically the yyyy-mm-dd format is right but it must be a simple string ie DATEWORKED = »’ + TSDateWorked + »’ when concatenating strings in pascal.

But instead of building the query as a string one should use parametrized queries. Parameters in SQL string are usually represented by name which has a colon in front of it, ie :DateWorked . So your query would look like

The query component usually also has ParamByName methods so that instead of parameter position you can assign values using the names. I don’t konw the TpFIBQuery component so the property/method names might differ, consult the help of the component.

Источник

Sql error code 104 firebird что значит

Posted via ActualForum NNTP Server 1.5

3 �� 13, 01:26��[14657321] �� | ��

Re: �� (Dynamic SQL Error. SQL error code = -206. Column unknown) [new]

��
Member

�� . � �� , � �� , �� ? �� .

3 �� 13, 12:05��[14657772] �� | ��

Re: �� (Dynamic SQL Error. SQL error code = -206. Column unknown) [new]

��
Member

��: ��
��: 13

��
�� ?

�� UPDATE �� , �� , �� , �� (�), �� (��) �� .

UPDATE
STOIM = 1000

� �� «Dynamic SQL Error. SQL error code = -206. Column unknown BILET_CENA_SUBSID_NV».

Источник

Sql error code 104 firebird что значит

Junior Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору Проинсталлировал FireBird 2.5 Beta.

Я себе пишу вроде мануала, чтобы была в будущем подсказка под рукой:
Прокоментируйте мои действия:
С isql.exe не разобрался,
для создания базы данных и таблицы в ней, использовал IB/FB Development Studio.

Запустить IB/FB Development Studio
Войти в Редактор Баз Данных.
Создать новую базу данных
Указать сервер, указать путь к файлу
Открыть Базу Данных
Правая кнопка мыши — создать объект (новую таблицу)
Правая кнопка мыши — создать поле, если нужно добавить первичный ключ и автоинкремент (создать генератор)

—————————————————————————-
Запустить Delphi2007
Создать новый проект
Из вкладки InterBase добавить на форму компонент TIBDatabase
Из вкладки InterBase добавить на форму компонент TIBTransaction
Из вкладки InterBase добавить на форму компонент TIBDataSet
Из вкладки Data Access добавить на форму компонент TDataSource
Из вкладки Data Controls добавить на форму компонент TDBGrid

—————————————————————————-
Настройка компонента TIBDatabase:
В свойстве компонента DefaultTransaction: имя компонента TIBTransaction
Двойной клик по компоненту (или правая клавиша мыши) — вызвать Database Editor
Remote
localhost
TCP
ввести путь к файлу базы данных
USER: SYSDBA
PASSWORD: masterkey
Свойство компонента Connected =TRUE

—————————————————————————-
Настройка компонента TIBTransaction:
В свойстве компонента DefaultDatabase: имя компонента TIBDatabase
Двойной клик по компоненту (или правая клавиша мыши) — вызвать Transaction Editor
Выбрать опцию Read Committed (для чтения и записи по подтвержением)
Свойство компонента Active =TRUE

—————————————————————————-
Настройка компонента TIBDataSet:
В свойстве компонента Database: имя компонента TIBDatabase
В свойстве компонента Transaction: имя компонента TIBTransaction
Двойной клик по компоненту (или правая клавиша мыши) — вызвать DataSet Editor
Select Table Name: (доступны только при активных предыдущих компонентах)
Select Primary Keys (либо выбрать вручную автоинкрементное поле)
Update Fields: (рекомендуется снять выбор с автоинкрементного поля)
Нажать кнопку «Generate SQL»
Свойства компонента DeleteSQL,InsertSQL,ModifySQL,RefreshSQL автоматически заполнятся.
Выбрать свойство компонента SelectSQL в Object Inspector, вызвать CommandText Editor
Выбрать таблицу, ввести SQL: Select * from (имя выбранной таблицы)

В свойстве компонента GeneratorField: выбрать имя генератора, выбрать поле, применить: On New Record
Свойство компонента Active =TRUE

—————————————————————————-
Настройка компонента TDataSource:
В свойстве компонента DataSet: имя компонента TIBDataSet:
Свойство компонента Enable =TRUE

—————————————————————————-
Настройка компонента TDBGrid:
В свойстве компонента DataSource: имя компонента TDataSource
Двойной клик по компоненту (или правая клавиша мыши) — вызвать Columns Editor
Если предыдущие компоненты активны (база данных подключена), то доступна кнопка «Добавить все поля» (Add All Fields)
В Дельфи, на вкладке Structure — компонент TDBGrid/Columns — выбрать столбец, задать его ширину в пикселях. Тем столбцам, которые не надо показывать — сделать Visible=FALSE (либо удалить из списка в столбцов в Columns Editor)

—————————————————————————————————————————
К сожалению, для информации у меня только книга Архангельского «Программирование в Delphi7» и интернет, поэтому будет много вопросов:

Вообщем, база данных подключилась. В базе данных Character Set = UNICODE_FSS (хочу и на русском и на европейских языках писать)
Если ввожу в текстовые поля английские символы — всё нормально, если ввожу русские — выдает ошибку «malformed string».

Далее, хочу создать программку, в которой можно самому программно создавать таблицы с полями.
Программный код создания таблицы отсюда: http://ibase.ru/devinfo/ibx.htm
create table X
(id int not null,
name varchar(30),
constraint PK_X primary key (id));

Мои вопросы — куда этот код вставлять? И как добавлять новые поля? Что это за ошибка «malformed string» (как от этого избавиться)?

Всего записей: 137 | Зарегистр. 12-07-2004 | Отправлено: 19:32 22-06-2009 | Исправлено: Kursist, 19:42 22-06-2009

volser

Advanced Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору Kursist

По поводу ошибки «malformed string» почитайте здесь IBase

Всего записей: 713 | Зарегистр. 31-03-2006 | Отправлено: 19:46 22-06-2009

X11

Silver Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору
Цитата:

С isql.exe не разобрался,
для создания базы данных и таблицы в ней, использовал IB/FB Development Studio.

Цитата:

скачай лучше
IBExpert
он на русском и для жителей бывшего СНГ бесплатен

———-
/не мы такие, жизнь такая/

Всего записей: 3241 | Зарегистр. 24-11-2005 | Отправлено: 20:31 22-06-2009

Kursist

Junior Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору volser
FireBird 2.5 Beta
Delphi2007

В компоненте IBDatabase обнаружил UTF8, а вот в
А вот в IB/FB Development Studio в свойствах базы данных только можно выбрать — UNICODE_FSS (UTF8 не обнаружил).

Как же быть?

Всего записей: 137 | Зарегистр. 12-07-2004 | Отправлено: 20:37 22-06-2009

X11

Silver Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору
Цитата:

Настройка компонента TIBDatabase:

Не увидел, с какой кодировкой ты базу создавал и с какой кодировкой подключаешься.

———-
/не мы такие, жизнь такая/

Всего записей: 3241 | Зарегистр. 24-11-2005 | Отправлено: 20:39 22-06-2009

Kursist

Junior Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору X11

Цитата:

скачай лучше IBExpert он на русском и для жителей бывшего СНГ бесплатен

ОПА: (http://www.ibase.ru/unicode_faq.html)
IBExpert не является unicode-приложением

15th June 2009
IBExpert new version with full Unicode support )) ХАРАШО!

Добавлено:
Скачал IBExpert. Запустил. Создаю новую базу. Тест не работает — ругается!
user name и password у меня по дефолту (SYSDBA|masterkey) и чего не так?

Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements.
Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

Server: Remote, ServerName: localhost, Protocol: TCP/IP, ServerVersion: FireBird 2.5
Database file: C:myBDBD3.fdb
Database Alias: localhost:C:myBDBD3.fdb

Test:
Attempting to connect to:
localhost:C:myBDBD3.fdb

Connecting. Failed!
————————————
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements.
I/O error during «CreateFile (open)» operation for file «C:MYBDBD3.FDB».
Error while trying to open file.
The system cannot find the file specified. .

Attempting to connect to services manager. Passed!

Disconnecting from database. Passed!

Я так понимаю, что файла этого нет, а разве он его сам не создает?

—————————————————————-
С этим разобрался. Надо было сначала базу данных создать, а уже потом ее регистрировать.
Поспешишь — людей насмешишь (опять!):
Error Message:
—————————————-
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements.
Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

Добавлено:
странно, в одном случае сервер (local), в другом localhost (надо самому вводить)

Не могу создать таблицу в базе данных (эти опции не активны в меню), предположительно это из-за ошибки доступа — не может подсоединиться, только почему я не пойму! Чисто административные проблемы, наверное, не люблю я такие проблемы — совсем это не программирование!

Всего записей: 137 | Зарегистр. 12-07-2004 | Отправлено: 20:43 22-06-2009 | Исправлено: Kursist, 21:48 22-06-2009

volser

Advanced Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору Kursist

Цитата:

Для полной поддержки unicode нужно использовать Delphi2009.

Всего записей: 713 | Зарегистр. 31-03-2006 | Отправлено: 22:35 22-06-2009

X11

Silver Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору
Цитата:

IBExpert не является unicode-приложением

Если быть внимательным, то ты не прав.

Цитата:

Для полной поддержки unicode нужно использовать Delphi2009.

Или компоненты типа TNT или DevExpress, или TMS

Цитата:

Тест не работает — ругается!

Сочувствую. Жди телепатов.

Цитата:

Я так понимаю, что файла этого нет, а разве он его сам не создает?

В эксперте выбери меню Создать новую базу. А ты что, подключаешься к несуществующей?

Добавлено:
У тебя Firebird-то хоть установился? Запущен?
Что даёт
telnet localhost 3051?
У тебя сетевой экран установлен? Антивирус установлен?

———-
/не мы такие, жизнь такая/

Всего записей: 3241 | Зарегистр. 24-11-2005 | Отправлено: 22:50 22-06-2009

volser

Advanced Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору X11

Цитата:

Начиная с Delphi2009.

Цитата:

Пакет для работы с unicode есть, но сами визуальные компоненты компоненты не являются unicode, поскольку построены на vcl.

Всего записей: 713 | Зарегистр. 31-03-2006 | Отправлено: 23:05 22-06-2009

Kursist

Junior Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору X11

Всё заработало. Перезагрузка ноутбука помогла.
В IBExpress теперь в новой базе данных создал таблицу с полями. Кодировка везде UTF8.

При подключении базы данных в Дельфи, пришлось использовать новый IBDataSet, так как в предыдущем были настройки на предыдущую базу данных, и генератов автоинкремента ключевого поля.
А новый компанент выдает ошибку при попытки его активации:

Цитата:

Dinamic SQL error
SQL code = -104
Token unknown — line 2, column 56
FILE

У меня в таблице нет столько полей/столбцов!

Добавлено:
Объясните, если возможно, почему в IBExpert регистрируешь базу данных, тестируешь — ОК:
——————————-
(Attempting to connect to:
LOCALHOST:C:myBDBD4.fdb
Connecting. Passed!
Server version: WI-T6.3.0.23247 Firebird 2.5 Beta 1
Attempting to connect to services manager. Passed!
Disconnecting from database. Passed!
——————————-

А когда пытаешься подключиться к базе данных, то выдает ошибку:
——————————
Error Message:
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements.
Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

(перевод:
Неудачное выполнение, вызванное ошибкой системы, которая устраняет успешное выполнение последующих утверждений.
Ваше имя пользователя и пароль не определены. Попросите, чтобы Ваш администратор базы данных настроил логин Firebird.)
С чего бы это!? Но ведь и user и password — введены регистрационную информацию! И тестовое подключение проходит успешно! Что за чушь!?

Добавлено:
Понял!
Ошибка появляется, когда выставляешь галочку:
Trusted authentication — снимаешь галочку — подключается без ошибки, с галочкой — ошибка! Только почему?!

Всего записей: 137 | Зарегистр. 12-07-2004 | Отправлено: 23:52 22-06-2009 | Исправлено: Kursist, 01:33 23-06-2009

X11

Silver Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору
Цитата:

Читай про Windows авторизацию в Firebird

———-
/не мы такие, жизнь такая/

Всего записей: 3241 | Зарегистр. 24-11-2005 | Отправлено: 09:23 23-06-2009

Kursist

Junior Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору Можете подсказать, как в IBExpert в уже созданной таблице удалить поле?

Всего записей: 137 | Зарегистр. 12-07-2004 | Отправлено: 14:46 24-06-2009

volser

Advanced Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору Kursist

Открыть таблицу. Перейти на закладку поля. Правой клавишей нажать на нужное поле. Выбрать пункт меню «Удалить поле. «

Всего записей: 713 | Зарегистр. 31-03-2006 | Отправлено: 15:03 24-06-2009

Kursist

Junior Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору Правый клик мышкой по полю.
В popup-меню:
New Filed
Edit Field
Drop Field
Create Foreign Key..
Reorder Fields
Copy Fields list to clipboard

Нет у меня «Delete Field»!

Если бы это было так очевидно, я бы не спрашивал.

Во вкладке DDL хотел удалить строку создания поля, в команде создание таблицы, но не разрешает..

Всего записей: 137 | Зарегистр. 12-07-2004 | Отправлено: 15:39 24-06-2009 | Исправлено: Kursist, 15:47 24-06-2009

data man

Advanced Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору Kursist
1. Если не открыт Эксплорер БД — нажать F11.
2. В нем (обычно он слева), в списке таблиц, найти нужную.
3. В списке полей, правый клик, в меню «Удалить поле» или нажать Ctrl-Del.

Если поле только одно, то удалить его таким образом нельзя.

P.S.
А какая версия IBExperta ?

Всего записей: 1696 | Зарегистр. 13-10-2005 | Отправлено: 15:53 24-06-2009

Kursist

Junior Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору data man

IB Expert — The Most Expert for InterBase, Firebird and Yaffil
Copyright (C) 2000-2009 IBExpert KG
All rights reserved.

Полей несколько.
Команды «удалить поле» — НЕТ!

Цитата:

В popup-меню:
New Filed
Edit Field
Drop Field
Create Foreign Key..
Reorder Fields
Copy Fields list to clipboard

+ не реагирует.

Всего записей: 137 | Зарегистр. 12-07-2004 | Отправлено: 16:06 24-06-2009

volser

Advanced Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору Kursist

Цитата:

Команды «удалить поле» — НЕТ!

А это что?
Цитата:

Всего записей: 713 | Зарегистр. 31-03-2006 | Отправлено: 16:07 24-06-2009 | Исправлено: volser, 16:07 24-06-2009

Kursist

Junior Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору
Цитата:

А! Это и есть УДАЛИТЬ! Бл. (Извиняюсь!)

Всего записей: 137 | Зарегистр. 12-07-2004 | Отправлено: 16:08 24-06-2009

data man

Advanced Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору Kursist
Может стоит переключить интерфейс IBExperta’а на русский ?
P.S. Здесь cсылка лежит более новый перевод, чем в инсталле.

Всего записей: 1696 | Зарегистр. 13-10-2005 | Отправлено: 16:25 24-06-2009 | Исправлено: data man, 16:38 24-06-2009

Kursist

Junior Member

Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору data man
в настройках язык интерфейса только English (Default)

Ещё вопрос:
У меня по закрытию формы проиходит отсоединение от базы данных:
IBDatabase1.Close;
А почему в Дельфи, по возвращению в среду IBDatabase1.Connected=TRUE
, это свойство не должно переходить в FALSE?

Добавлено:
IBExpert
Опять натолкнулся на проблему:
Пытаюсь связать 2 таблицы (ORDERS и CLIENTS),

Вот такой скрипт получается:

alter table ORDERS
add constraint FK_ORDERS_1
foreign key (CLIENTS_NAME)
references CLIENTS(NAME)

This operation is not defined for system tables.
unsuccessful metadata update.
could not find UNIQUE or PRIMARY KEY constraint in table CLIENTS with specified columns.

Источник

Adblock
detector

Источник

Hadoop Installation Modes

Assigning Hostname to Linux System

Hadoop Streaming

fresher job

How to Change the Keyboard layout in Linux

Setup Single Node HADOOP cluster

what is big data

WHAT IS HADOOP

Non DB2 COBOL program execution

What is the purpose of command NRDAY in CA-7

Extract a few members from a PDS

Run SSIS Packages from Micro Focus Enterprise Server JCL

OMIT the records if space occurs in any place of a Five length filed….

Microsoft Cobol Compiler v 2.20

Unix Daemon like background process in Mainframe

IBM is hiring freshers — 2013 Pass out and 70 % throughout

Difference between AS400 and IBM mainframe

Openings in SOPRA NOIDA

Year as last qualifier of dataset in a job

Removing line numbers from col 73 till 80

gmail partial word search

Copy DB2 table records to PS file using REXX tool

Sort

sql code -804

Textpad Macro

Mainframes Sorting from PS file

Mainframes opening in Gurgaon

timezone in rexx

Need Help on OUTREC in JCL

Full form of SOC7

File Manager

EZA1735I Std Return Code = 07550, Error Code = 00002

Nested Proc

rename clause

value in the renamed field after move statment

difference between mainframe COBOL and Micro Focus COBOL

Delete the record

FTP failure

between

COBOL dynamic Variables

decommisioning a job

Reg:Comp3

EZA1735I Std Return Code = 27000, Error Code = 00007

-CAUTION- Profile changed to NUMBER ON STD (from NUMBER OFF)

Mainframe file

IEBPTPCH print PDS members to a file in alphabetical order

JCL Realtime questions

CREATION OF VSAM FILE

Split a file using delimiter in jcl

sequential access

Unanswered Forum Posts

DB2 Plan name for Test

I am not able to see job status in sdsf while issuing a command «s.i»

test jcl for errors

regarding taking backup of a file

Writing 2 output from one Sort

Provide the details required to raise SOBR request in mainframe

SYSTEM COMPLETION CODE=0C1 REASON CODE=00000001

compile and Link JCL for IMS program

xpediter manual

how to get the sign value of a filed (+,- or unsigned) from Packed decimal to flat file in Easytrieve(EZTP)

COBTRACE code for cobol

Convert Packed format to viewable format using file-aid

Pass data from clist to REXX

How to get space used by a file

SAR BATCH MANUAL

FTP huge file on mainframe

How to find number of similar HLQ members in a single PDS.

Trigger jobs using wait time

record count of PS file using file aid

CLIST to extract member names

Create PDS using CLIST

Copy members using CLIST from one pds to another

CLIST to write data in PS file

convert a VB file to FB

Need FTP delete card to delete the files from shared folder

Creating a file using CLIST

pls tell me any one

JOB

SUM DECIMAL VALUE USING SYNCSORT

ISPS100 Invalid service name

Reading file sequentially in CLIST

cics

PC to Mainframe

Current schedule loaded in OPC

Read access to my PDS

JCL SORT

spool backup jobs

COBOL Double Precision Multiply

OPER no in OPC scheduler

Display database

Is it possible to find how many mainframe-ids are working this time in a company?

how to get a sar job back to ejes?

Unload all the members of PDS(VB) to PS file

Problem with SORT OUTRFIL and OUTREC

How a data in physical and symbolic map gets treated

Add a new job in control-m

Capturing mainframe screens

Open a mainframe file in append mode in clist

FTP Command to convert EBCDIC to ASCII

How can the system z mainframes (z10 and forward) and software address the Big Data power drain?

To update card dynamically

what is NRWS in OPC

No Delete step in JCL contains UCC 11

Get member name for ISREDIT macro

Job Openings with Hughes Communications India

How to download textpad

SORT TUTORIALS

JCL TUTORIALS

How to grant update access to my mainframe id

legacy modernization

Job Opening in Siemens

Conversion from Character to Binary

rexx db2 cursor

What is COBOL

Get List of running jobs in IOF

List all datasets starting with Qualifier

IBM History

send email using SMTPNOTE in mainframe

sort to calculate date difference

IT companies

List of mainframe companies

mainframe jobs

IT roles

Submit job from CICS and COBOL

What is the use of IEBUPDTE

IT roles in programming

How to capture a value entered in an HTML page on to the Back end in mainframes.

cost saving mainframe project

Replace FTP with SFTP

What is IBM

What is DB2

Shortcuts in xpediter

IT roles in Project Management

IT roles in Network management

Hot IT Skills

IT roles in Technical writing

IT roles in web development

IT roles in database administration

IT roles in Hardware management

IT roles in techincal support

IP Address for CryptoTerm

IT Positions

How to check the version of zos

IT software

JCL to XML conversion help

Non COBDB2 program calls COBDB2 program

Is binding required when program does not refer a newly added column

Compare two files and write matching records to a file and unmatched to another

Update data in table with primary key and foreign key constraint

Can foreign key be defined on unique index

Can unique index be created on more than one columns

Test changes to COBOL DB2 program

GDG versions in a JCL

Prospects of Mainframes Programmers in 2012

db2 plan used by CICS region

How to check the version of Syncsort

Julian calendar leap Year

How is mainframe for 2012 in india for a fresher

What is file status code of 02 in COBOL

How to check the version of DB2 on mainframe

Moving spaces to numeric field

Julian calendar non leap Year

email attachment from mainframe

(FOC198) FATAL ERROR IN DATABASE I/O. FOCUS TERMINATING

Customize SORT

How to setup xpediter on mainframe

Synsort for subtotal

COBOL TUTORIALS

Convert easytrieve to COBOL

DB2 TUTORIALS

Tata Consultancy Services NOIDA sector 63

Mainframe interview questions

FTP target file with date and time qualifier

Why RRDS VSAM does not support alternate index

How to set maxcc=0???

mainframe jobs at TCS

mainframe computer

How to view packed data without file manager or file aid

Monitoring job delays

how to check the version of IMS database

Delete few records from a flat file

NOIDA 5 Address Tata Consultancy Services (TCS)

Difference between copy pending and check pending

Which is better with respect to memory usage COMP or COMP-3

What is the LRECL for printer files in COBOL

What is AMODE and RMODE

what is the use of getmain and freemain in cics?

Cloning a DB2 table

What is a Page in DB2

Can DB2 directory be accessed using SQL commands

Extend the expiry date of dataset

Primary index drops when primary key dropped

Which is more efficient «Between phrase» or «greater, lesser equal phrase»

can alter be used to alter views and indexes

Can DB2 interface with IMS-DB and IMS-DC

Can a table have more than one primary key

Different levels of locking in DB2

What is the latest version mainframe

Execute COBOL program using REXX

Loading VSAM data from EBCDIC environment to ASCII environment

Sorting a VB file giving unexpected results

Retrieving Job from SAR

Alternat Index file in VSAM upon loading VSAM file

Compiler option for getting statement of abended line

What is uncommitted read and when it is used

Would Standalone cobol program need link editing

Basics of XPEDITOR

How to make a COBOL program reentrant

Why external sort better than internal sort

Plan or package which is executable

mainframe files — strip spaces/blanks/x’40’

Viewing VSAM file without File Aid or File manager

Can we read empty VSAM file using COBOL

fetch multiple rows without using CURSORS

read a sequential file in reverse order in COBOL

Difference between Include and Jcllib

To sort an output file having duplicates using sort.

Screen scraping tool for emulator

Un initialized variables in system

reformat packed comp-3 fields using file-aid

S0C7 on Moving alphanumeric data to COMP-3

Delete the latest version from endevor

linkage in COBOL

Cobol Get Cloudy

Last modified date of a PS file

Display Hex codes

Restart a step in Nested Proc

Execute REXX CLIST at logon

How to send sms from mainframe

Difference between Library and PDS

Instream or Catalog proc in JES spool

Some amazing facts about mainframe

GDG version in report

Difference between Copy and Include

Attributes of a Tape dataset

Reading last record in VSAM file

PLAN_TABLE and EXPLAIN command

New indexes to be used by COBDB2 program

Walk-in 10th/14th/21st/28th Sep for Mainframe Developer/Sr. Developer/Module leadTech lead

How to create dynamic array in COBOL

What is Tandem Cobol

Calling REXX from COBOL

COBOL program to delete a PS file

Signout error in endevor

Add 1 to Hex values in cobol

Compare two PDS

How to pass data from COBOL to JCL

How to run JCL using COBOL

Prerequisites for concatenating datasets

Splitting a file into equal number of records

Skipping xth and yth records in a file

How to View the RCT entry for a CICS trx

CICS command to know program name allocated to CICS transaction

CICS command to know DSN name allocated to CICS file name

Called program static or dynamic calling

DB2 commit question

Skip first n records and last n records in a file

Handle Ignore and Resp which one to use

DB2 702 certification study materials

ISPF tips and tricks

Limit on size of array in cobol program

Changing the attributes of column in a Table

How to fetch last n rows only in DB2?

CSC,Exp:6-10yrs,Skillset-C++,Job-location:Chennai

Is it possible to password protect datasets?

How to calculated maximum space using primary and secondary units

Why VARCHAR item in COBOL must be defined at 49 level?

Subprogram containing DB2 Cursor called multiple times

Cursor remain open or close when control returns to calling program

Any free mainframe emulator for practicing COBOL etc

GalaxE-Exp:5-8yrs,Job-location:Blr-Noida

CICS program does not need to open a file explicitly

Converting Easytrieve code to COBOLcode

max length of data passed from JCL to COBOL

How to skip the first step in a Job

Relation between BLKSIZE and LRECL

Why do we code BLKSIZE=0 in JCL

Synova, Exp:5-6yrs,Job location:Bangalore

Magna Infotech,Exp:5+,Job location:Bangalore

Difference between FB and FBA RECFM

Edited Numeric item not getting initialized

TCS,Exp:2-8 Yrs,Job-Location:Delhi/NCR-23rd July 2011

NIIT Tech,Exp:3-8 Yrs,Job-Location:Delhi/NCR-23rd July 2011

What is special about this COBOL program

About IBM

Why does Storage control program has no corresponding CICS table

When would Include command in Jcl get expanded

Relation between Plan, Packages and collection

PC equivalent of fileaid

Subquery used in Where returns more than one row

Db2 question which query will not work

Searching for Hex values in COBOL program

How to run jobs in ASCII charset on mainframe express

Replacing data in all members of a PDS

How to convert a VSAM file to flat file?

How to get the attributes of a file on Tape?

How many plans packages needed?

Dynamic calling giving S0C1 abend while calling subprogram

COBCH0576S Preceding statement is not imperative

What changes required for changing Static calling to dynamic calling

Access database at two LPARs using COBOL

On size error truncation or no effect

Real life example of -805 sql code

Display hexadimal values using COBOL

Compiling COBOL in ASCII mode in mainframe express

Mainframewizard App for your NOKIA phone

Finding the Length of a string

Length of each record in Variable file

Do we have REVERSE command in COBOL?

Can we display value of Index in COBOL

IP address using the mainframe id

Purpose of TYPRUN COPY in JCL

Comparing two files in batch mode

Problems in Editing a huge file

Compile and Run JCL for a COBOL program

Easytrieve equivalent of S9(7)V99 Comp-3 in COBOL

Converting EBCDIC data to ASCII format

How to find the last run time of reorg and runstats

SEARCH ALL not searching the entire Table

How to control TSO session Time

How to SAVE list of members in a PDS

Index dropped and recreated error in DSN1COPY step

Elements Signed out to an ID in endevor

How to check Copy Pending Flag and fix it

Pull data from SAR using date as filter

CANCEL command to CANCEL calling program

LRECL limit of SPUFI output dataset

Difference between performing section and paragraph

Difference between CONTINUE and NEXT SENTENCE

What is the Size of S9(18)V99 COMP-3

Dynamically called program stays in memory

Difference between Static and Dynamic call

Examples of Inner Join, Left Outer Join, Right outer join

What is file status 9 and status key 13 in VSAM?

What is the COMP-X used for?

Grant with Grant on Views

Notifying multiple users using JCL

Static linking change made to called program not calling program

Can we call a Cataloged Proc from another cataloged Proc

FTP file to from mainframe in Batch

How to read a VSAM file with Partial Key

What is the difference between OS/390 and z/OS

DB2 cursor close if commit issued

Why Varchar columns use level number 49

Maximum length of a DB2 Column Name

Difference between Primary key and Unique Key

Order By Clause in DB2

EJECT command in COBOL

What is Cancel command in COBOL used for?

What is the difference between Stop Run and Go Back

Manipulation with DB2 dates times and timestamps

How to get the number of members in a PDS without opening it?

SQL CODE -625 while creating primary key

How to select nth max salary from employee table?

How to concatenate strings in Ezytrieve

Adding new column and altering Primary Key of DB2 Table

Submit selected steps in JCL without altering it

Load VSAM data to DB2 TABLE

DDNAMES prefixed with UT in COBOL program

Passing data from COBOL to JCL

How to send email from mainframe?

LRECL and RECFM for flat file created by VSAM unload

Converting date in Julian format to Gregorian format

convert COMP-3 data in readable mode

Printing copybook layout to a file

where to look for the version of zOS?

What is an ASRA abend?

What is the purpose of using SYNC in COBOL?

What is the difference between Disp=MOD and Disp=OLD

Why we need Variable blocked files?

Can we redefine a PIC X(100) item to X(200)?

Can anyone help me in taking dump of a DB2 table?

How to bring a Job back from SAR to Spool?

Is it possible to submit a JCL in loop?

what is the difference between comp and comp-3 in COBOL?

Running Exe on mainframe

precompile compile and link edit jcl for cobol db2 program

Record length of DB2 Table

DIFFERENCE BETWEEN COBOL SEARCH AND SEARCH ALL

SELECT INTO SQL SERVER AND SELECT INTO DB2

SQL code -305

IBM Websphere application server

SQL code -905

SQL CODE -904

SQL code -204

Sql Code -803

db2 interview questions with answers

JCL interview questions

CICS Interview Questions with answers

What is a GDG?

JCL interview question 2

JCL interview question 1

migrating from mainframe to micro focus MFE

How many Exec Statements can a JCL have at maximum?

How to Delete Duplicate Rows from DB2 Table

What is the difference between Cursor stability and Repeatable read.

What is a db2 package?

What is db2 plan

Difference Between Catalog and Instream Procs

What is mainframe express

tso line commands

Alias of DB2 Table

Synonym of DB2 Table

mainframe tips

unused tape dataset report

Would mainframe technology be relevant in the age of cloud computing?

COBOL TO RECEIVE DATA FROM JCL

Creating Primary Key while creating DB2 Table

Changing the primary key on existing DB2 Table

Adding Primary Key on exisitng DB2 Table

Drop Primary Key on DB2 Table

Create a DB2 Table

Drop Index of a DB2 Table

Drop Table DB2

Wildcard character underscore in DB2

Wildcard character percent in DB2

mainframe jobs india

What is a VSAM?

S322 Abend

S222 Abend

S822 Abend

S0C4 Abend

S0C7 Abend

JCL to create members using Flat File

JCL to create new members in a PDS using IEBUPDTE

Walk-ins at Bangalore

Walk-ins at Chennai

Walk-ins at Hyderabad

Walk-ins at NOIDA

What is Cloud computing

mainframe websites

Submit Articles

SORT using REXX

Free mainframe Tools

Free mainframe emulators

Free COBOL compilers

Copy flat file to VSAM file

JCL to Unload all members of PDS in a PS Flat file.

What does EXCP in SDSF mean

Cricket World cup 2011 India

Mainframe Disaster Recovery

What is a MAINFRAME?

TSO ISPF

List all signed out elements in endevor

Saving breakpoints in xpediter

How to assign a PF Key to a command

How to retrieve the last command issue

How to list the commands issued earlier

How to compare a dataset with other dataset while viewing or editing it

How to find datasets last referenced by you

How to find who is using your dataset

How to find the TSO region in which you are logged on

How to find the changes since last save?

UNSTRING DELIMITED ON OVERFLOW

UNSTRING DELIMITED WITH POINTER OPTION

UNSTRING DELIMITED BY IDENTIFIER

UNSTRING DELIMITED BY LITERAL

STRING DELIMITED ON OVERFLOW

STRING DELIMITED WITH POINTER

DIFFERENCE BETWEEN STRING and MOVE

STRING DELIMITED BY SIZE

STRING DELIMITED BY IDENTIFIER

STRING DELIMITED BY LITERAL

INSPECT REPLACING CHARACTERS BY LITERAL BEFORE INITIAL LITERAL

INSPECT REPLACING LEADING SAPCES BY LITERAL

INSPECT REPLACING ALL SPACES BY LITERAL

INSPECT TALLYING FOR CHARACTER AFTER INITIAL SPACES

INSPECT TALLYING FOR CHARACTER BEFORE INITIAL SPACES

INSPECT TALLYING FOR CHARACTER

INSPECT TALLYING FOR LEADING ZEROES

COBOL INSPECT TALLYING FOR LEADING SPACES

INSPECT TALLYING FOR ALL IDENTIFIER

COBOL INSPECT TALLYING FOR ALL LITERAL

COBOL INSPECT TALLYING FOR ALL SPACES

COBOL EVALUATE TRUE ALSO TRUE

COBOL EVALUATE ARITHMETIC EXPRESSION

COBOL EVALUATE CONDITIONAL EXPRESSION

COBOL EVALUATE LITERAL

COBOL EVALUATE IDENTIFIER

COBOL EVALUATE FALSE

COBOL EVALUATE TRUE

COBOL PERFORM VARYING UNTIL

COBOL PERFORM TIMES

COBOL PERFORM WITH TEST AFTER

COBOL PERFORM WITH TEST BEFORE

COBOL PERFORM UNTIL

COBOL GO TO DEPENDING ON

COBOL PERFORM THRU

COBOL PERFORM PARA

COBOL INLINE PERFORM

COBOL JUST RIGHT CLAUSE

PACK ON/OFF

Generate list of files in a folder using DOS

RECORD AND PLAY TEXTPAD MACROS

JCL FOR SPLITTING DATA USING OUTFIL

COMMON JCL FOR SORT

SORT JCL to Split data using OUTFIL

SORT JCL to SUM up values

SORT JCL to copy when location of matching data is not known

SORT JCL to Mask output data

SORT JCL to put SPACES end of record using INREC or OUTREC

SORT JCL to append data in a record using INREC or OUTREC

SORT JCL to filter data using INREC or OUTREC

SORT JCL with OMIT

SORT JCL with INCLUDE

SORT JCL to sort in Char format

SORT JCL with STOPAFT and SKIPREC

SORT JCL with SKIPREC

SORT JCL with STOPAFT

SORT JCL to Copy all records

Update Data in one DB2 table using data in another table

Update Data in one column of a DB2 Table using data in another column

Set Breakpoint before every CALL in xpediter

disclaimer

Page Not found message

File Manager to get record count of VSAM

Compress PDS — abend SE37

Wrapping data at a particular column

Searching a member in more than one pds at a time

Autocomplete feature on mainframe

Retain the last executed command on command line

Search string contains quotes

Low values to Spaces using SORT

Selecting various groups in SDSF

Transfer file from and to mainframe using FTP

Check if Day light saving is in Effect

DB2 TIPS

If the VSAM is empty then copy job abends

Check for empty file

Difference in number of days using DB2 days function

Description of a DB2 Table

Copying files from Tapes to DASD

DB2 query to select first or last N rows

JCL to submit particular steps of another JCL using IEBEDIT

Welcome to Mainframewizard

WIN32 Sality Virus remover

SORT Tips and Tricks and Examples

abend tracker

Verification of CONTOKEN in SYSPACKAGE DBRMLIB LOADLIB

SUPERCE in Batch to compare datasets

Ten Steps to Setup Hercules Turnkey Mainframe emulator

Date and timestamp in load object

COBOL Allowed Moves

REXX to Connect with DB2

CLIST to put flower box

Clist to Tag COBOL code

Rexx to Save in View Mode

JCL to List Migrated Datasets

JCL Examples

Sort JCL to Remove duplicates

JCL to list all datasets starting with

JCL TO CONVERT VB TO FB FILE

Initialize a filler in cobol

mainframe tutorials video

mainframe tutorials

Testimonials

cobol-interview-questions-6

COBOL INTERVIEW QUESTIONS-5

COBOL INTERVIEW QUESTIONS-4

COBOL INTERVIEW QUESTIONS-3

COBOL INTERVIEW QUESTIONS IN PDF

COBOL INTERVIEW QUESTIONS WITH ANSWERS

COBOL INTERVIEW QUESTIONS

COBOL EDITED PICTURE CLAUSE

COBOL DIVIDE VERB

COBOL MULTIPLY VERB

COBOL SUBTRACT VERB

COBOL ADD VERB

COBOL RENAME CLAUSE

COBOL REDEFINE CLAUSE

COBOL-ACCEPT and DISPLAY

COBOL smallest program