/* Generated by Oracle Rdb SQL V7.2-200 at 19-FEB-2009 13:17:48.33 */
/* Source file is DISK$SYSMAN:[LAISHEV.WORK.BBS-RDB]BBS_SQL.SQLMOD;293 */
#ifndef _BBS_SQL_H_
#define _BBS_SQL_H_
#ifdef __cplusplus
extern "C" {
#endif /* __cplusplus */

extern void DB_OPEN_CATCUR (
                long *SQLCODE                                   /* out    */
	);

extern void DB_OPEN_SUBCATCUR (
                long *SQLCODE                                   /* out    */
                ,long *P_CATID                                  /* in     */
	);

extern void DB_OPEN_UATCUR (
                long *SQLCODE                                   /* out    */
	);

extern void DB_OPEN_TOPIC (
                long *SQLCODE                                   /* out    */
                ,long *P_SUBCATID                               /* in     */
	);

extern void DB_CLOSE_CATCUR (
                long *SQLCODE                                   /* out    */
	);

extern void DB_CLOSE_SUBCATCUR (
                long *SQLCODE                                   /* out    */
	);

extern void DB_ROLLBACK (
                long *SQLCODE                                   /* out    */
	);

extern void DB_CLOSE_UATCUR (
                long *SQLCODE                                   /* out    */
	);

extern void DB_CLOSE_TOPIC (
                long *SQLCODE                                   /* out    */
	);

extern void UAT_ADD (
                long *SQLCODE                                   /* out    */
                ,long *P_UIC                                    /* out    */
                ,char P_NAME[12]                                /* in     */
                ,char P_PASS[32]                                /* in     */
                ,char P_EMAIL[128]                              /* in     */
	);

extern void UAT_GET (
                long *SQLCODE                                   /* out    */
                ,long *P_UIC                                    /* in     */
                ,void *P_UAT_ROW                                /* out    */
	);

extern void CAT_GET (
                long *SQLCODE                                   /* out    */
                ,long *P_ID                                     /* in out */
                ,void *P_CREATED                                /* out    */
                ,char P_NAME[64]                                /* out    */
                ,char P_LDESC[512]                              /* out    */
                ,long IND_ARRAY[4]                              /* not used */
	);

extern void UAT_LOGIN (
                long *SQLCODE                                   /* out    */
                ,char P_NAME[12]                                /* in     */
                ,char P_PASS[32]                                /* in     */
                ,void *P_UAT_ROW                                /* in out */
	);

extern void UPT_GET (
                long *SQLCODE                                   /* out    */
                ,long *P_UIC                                    /* in     */
                ,void *P_UPT_ROW                                /* out    */
	);

extern void UAT_LIST (
                long *SQLCODE                                   /* out    */
                ,void *P_UAT_ROW                                /* out    */
	);

extern void UAT_MOD (
                long *SQLCODE                                   /* out    */
                ,long *P_UIC                                    /* in     */
                ,char P_NAME[12]                                /* in     */
                ,char P_PASS[32]                                /* in     */
                ,long *P_FLAGS                                  /* in     */
                ,long *P_PRIVS                                  /* in     */
                ,void *P_LASTLOGIN                              /* in     */
	);

extern void UAT_DEL (
                long *SQLCODE                                   /* out    */
                ,long *P_UIC                                    /* in     */
                ,char P_NAME[12]                                /* in     */
	);

extern void CAT_ADD (
                long *SQLCODE                                   /* out    */
                ,long *P_ID                                     /* out    */
                ,char P_CAT_NAME[64]                            /* in     */
                ,char P_LDESC[512]                              /* in     */
	);

extern void CAT_UPD (
                long *SQLCODE                                   /* out    */
                ,long *P_ID                                     /* in     */
                ,char P_CAT_NAME[64]                            /* in     */
                ,char P_LDESC[512]                              /* in     */
	);

extern void CAT_DEL (
                long *SQLCODE                                   /* out    */
                ,long *P_ID                                     /* not used */
	);

extern void CAT_LIST (
                long *SQLCODE                                   /* out    */
                ,void *P_CAT_ROW                                /* out    */
	);

extern void SUBCAT_ADD (
                long *SQLCODE                                   /* out    */
                ,long *P_CAT_ID                                 /* in out */
                ,long *P_ID                                     /* out    */
                ,long *P_MODER1                                 /* in     */
                ,long *P_MODER2                                 /* in     */
                ,long *P_MODER3                                 /* in     */
                ,char P_CAT_NAME[64]                            /* in     */
                ,char P_LDESC[512]                              /* in     */
	);

extern void SUBCAT_UPD (
                long *SQLCODE                                   /* out    */
                ,long *P_ID                                     /* in     */
                ,long *P_MODER1                                 /* in     */
                ,long *P_MODER2                                 /* in     */
                ,long *P_MODER3                                 /* in     */
                ,char P_CAT_NAME[64]                            /* in     */
                ,char P_LDESC[512]                              /* in     */
	);

extern void SUBCAT_LIST (
                long *SQLCODE                                   /* out    */
                ,void *P_SUBCAT_ROW                             /* out    */
	);

extern void SUBCAT_GET (
                long *SQLCODE                                   /* out    */
                ,long *P_ID                                     /* in     */
                ,void *P_SUBCAT_ROW                             /* out    */
	);

extern void TOPIC_LIST (
                long *SQLCODE                                   /* out    */
                ,void *P_TOPIC_ROW                              /* out    */
	);

#ifdef __cplusplus
}
#endif /* __cplusplus */
#endif /* _BBS_SQL_H_ */