MVSFORUMS.com

Thanks Kolusu.

Hi,

We have a few Mainframe components developed in "Format Control Language". However, we do not have any documentation available for understanding the piece of code. Could you please he ...

Hi,

One of my friend is looking to prepare for DB2 9 Fundamentals certification 730 and is looking for some sample / model questions. Would be great if some one can please provide the pointers.

...

Thats great Kolusu. You have all answers for my problem.

Apologize for bothering you ... As I understand some of the datasets are migrated to tape while some onto the disk. Please correct me if I ...

Thanks Kosulu. It worked. But, the job has sent a recall request to the datasets of the specified pattern and completed with a return code of ZERO. When I tried viewing them using 3.4 many of them are ...

Hi kolusu,

Thanks for the imm. reply.

I am not getting any errors. Surprisingly I am not getting SYSTSPRT. I checked the spool and I am not getting any translation of the widlcard. I also checke ...

Hi,

How can i recall multiple PS of a specific pattern, just by specifying the HLQ, using IEFBR14. I tried executing the below mentioned code, but the migrated datasets are not being recalled -
...

Thanks Kolusu

What values could it be then?

Thanks,
Vijay

Please find the values below -

00CF
003C
0000
0000
0000
0000

I am thinking to use the code you have suggested in threads of your first reply to create the SQLCARDS

Cond from the prev thread ..

Please find the table definition below

CREATE TABLE <table_name>
(C1 CHAR ( 0001 ) NOT NULL ...

Yes, I am sure. Please find the details below -

DCLGEN

EXEC SQL DECLARE <table_name> TABLE
( C1 CHAR(1) NOT NULL,
...

Thanks for the clarifications Kolusu.

Hopefully a last query. I have some COMP-3 data in one of the datasets that is being loaded to the database into smallint type of column. As per my knowledge, ...

The information could be obtained from SYSIBM.SYSKEYS. You need to provide the index name in your where clause.

SELECT * FROM SYSIBM.SYSKEYS WHERE IXNAME LIKE 'X1%' in your case.

Thanks,
Vijay

Thanks kolusu.

Can you please address my questions 'b' and 'c' in my earlier thread on locking and consistency?

Thanks,
Vijay