STUB.SQC error

[Gagan Kakkar]

Hi there,

Any idea what's the issue here ? 

LINE    MESSAGES FOR STUB.SQC

------  --------------------------------------------------------------------

        SQL0060W  The "C" precompiler is in progress.

   45   SQL0008N  The token "DATABASE_LEN" found in a host variable 

                  declaration is not valid.

  189   SQL4911N  The host variable data type is not valid.

        SQL0095N  No bind file was created because of previous 

                  errors.

        SQL0091W  Precompilation or binding was ended with "3" 

                  errors and "0" warnings.

 

NMAKE : fatal error U1077: '"C:\Program Files (x86)\CA\Gen86\Gen\TIDB2PRP.EXE"' : return code '0xffffffff'

Stop.

Thanks.

------------------------------
Gagan.

------------------------------

[Lynn Williams]

Hi @Gagan Kakkar,
I see you are actually referring to STUBDB2N.SQC
I was doing some custom testing with STUBDB2N.SQC for this article earlier this year Gen GUI application using Windows logon authentication to DB2 database and came across the same error after running STUBDB2N.MAK. I forgot to actually highlight the error in that article.
The STUBDB2N.SQC in PTF WKS86400 is from PTF RTN86307 and is where the DATABASE_LEN was first introduced.
I also just repeated the same error with WKS86400 installed.
As per the article, you can workaround the problem by hard coding the DATABASE_LEN value in line 45 of STUBDB2N.SQC i.e. change as follows:

    Line  24: #define DATABASE_LEN 30
    Line  45: char Database[DATABASE_LEN];                            //  vuln fix
    Line 111:    strcpy_s(Database, DATABASE_LEN, szDatabase);   

To:
    Line  24: #define DATABASE_LEN 30
    Line  45: char Database[30];                            //  vuln fix
    Line 111:    strcpy_s(Database, DATABASE_LEN, szDatabase);   


I will now create a separate knowledge article for it and also flag it with Engineering so we can get it fixed in a PTF.

Regards

Lynn

------------------------------
Lynn Williams
Senior Principal Support Engineer
Broadcom Software
Australia
------------------------------

[Lynn Williams]

Hi @Gagan Kakkar,
You may then hit later problems due to other issues with STUBDB2N.MAK.
See this article which has a modified version: STUBDB2N.MAK error "The file cannot be copied onto itself"

Regards

Lynn

------------------------------
Lynn Williams
Senior Principal Support Engineer
Broadcom Software
Australia
------------------------------

[Gagan Kakkar]

Hi @Lynn Williams,

This fix worked:    
Line  45: char Database[30];                            //  vuln fix

Did not get any issue with STUBDB2N.MAK.

Many thanks !

Regards,
Gagan

------------------------------
Gagan Kakkar
IT Consultant (Mainframe)
Ph: [phone]
------------------------------

[Lynn Williams]

Hi @Gagan Kakkar,
Good to hear that.
I checked with Engineering and after what I found earlier this year there is already a new PTF planned to fix the STUBDB2N.SQC problem plus the issues with STUBDB2N.MAK (interesting that you did not hit those).
The PTF will be RTN86403.

Regards

Lynn

------------------------------
Lynn Williams
Senior Principal Support Engineer
Broadcom Software
Australia
------------------------------

[Gagan Kakkar]

Thank you @Lynn Williams
I am all set for now. Will apply the PTF as and when available. 

I can see you have created a new KB article for this. 
https://knowledge.broadcom.com/external/article?articleNumber=399346

Regards,
Gagan

------------------------------
Gagan Kakkar
IT Consultant (Mainframe)
Ph: [phone]
------------------------------