ogg112101_ggs_Windows_x86_ora10g_32bit

  • o5_166729
    了解作者
  • 30.1MB
    文件大小
  • zip
    文件格式
  • 0
    收藏次数
  • VIP专享
    资源类型
  • 0
    下载次数
  • 2022-03-30 19:29
    上传日期
ogg112101_ggs_Windows_x86_ora10g_32bit
ogg112101_ggs_Windows_x86_ora10g_32bit.zip
  • UserExitExamples
  • ExitDemo_more_recs
  • exitdemo_more_recs.c
    30KB
  • Makefile_more_recs.SOLARIS
    3.4KB
  • Makefile_more_recs.HPUX
    3.4KB
  • Makefile_more_recs.AIX
    3.3KB
  • Makefile_more_recs.LINUX
    3.4KB
  • exitdemo_more_recs.vcproj
    13.2KB
  • readme.txt
    4.1KB
  • ExitDemo_pk_befores
  • Makefile_pk_befores.SOLARIS
    1.9KB
  • exitdemo_pk_befores.c
    35.5KB
  • Makefile_pk_befores.HPUX
    1.9KB
  • Makefile_pk_befores.AIX
    1.9KB
  • exitdemo_pk_befores.vcproj
    13.2KB
  • Makefile_pk_befores.LINUX
    1.9KB
  • readme.txt
    8.5KB
  • ExitDemo_passthru
  • Makefile_passthru.SOLARIS
    1.9KB
  • Makefile_passthru.HP_OSS
    1.9KB
  • exitdemo_passthru.c
    19.9KB
  • Makefile_passthru.AIX
    1.9KB
  • Makefile_passthru.LINUX
    1.9KB
  • Makefile_passthru.HPUX
    1.9KB
  • exitdemopassthru.vcproj
    13.2KB
  • readme.txt
    2.3KB
  • ExitDemo
  • Makefile_exit_demo.SOLARIS
    1.9KB
  • exitdemo.vcproj
    14.6KB
  • Makefile_exit_demo.AIX
    1.9KB
  • exitdemo.c
    48.8KB
  • Makefile_exit_demo.HPUX
    1.9KB
  • Makefile_exit_demo.HP_OSS
    1.9KB
  • exitdemo_utf16.c
    44.6KB
  • Makefile_exit_demo.LINUX
    1.9KB
  • readme.txt
    501B
  • ExitDemo_lobs
  • Makefile_lob.AIX
    3.4KB
  • Makefile_lob.SOLARIS
    3.4KB
  • exitdemo_lob.c
    32.7KB
  • Makefile_lob.HPUX
    3.4KB
  • Makefile_lob.LINUX
    3.4KB
  • exitdemo_lob.vcproj
    13.2KB
  • readme.txt
    5.1KB
  • cfg
  • MPMetadataSchema.xsd
    3.4KB
  • jps-config-jse.xml
    1.4KB
  • ProfileConfig.xml
    74B
  • Config.properties
    6.7KB
  • password.properties
    1.3KB
  • mpmetadata.xml
    7.7KB
  • dirprm
  • jagent.prm
    53B
  • dirjar
  • jps-mbeans.jar
    495.8KB
  • org.springframework.beans-3.0.0.RELEASE.jar
    539KB
  • xmlparserv2.jar
    1.4MB
  • org.springframework.web-3.0.0.RELEASE.jar
    350.7KB
  • org.springframework.orm-3.0.0.RELEASE.jar
    322.5KB
  • commons-codec-1.3.jar
    45.6KB
  • jps-common.jar
    914.2KB
  • jdmkrt-1.0-b02.jar
    2.4MB
  • commons-logging-1.0.4.jar
    37.1KB
  • jps-wls.jar
    47.4KB
  • spring-security-taglibs-3.0.1.RELEASE.jar
    18.2KB
  • jps-ee.jar
    44.5KB
  • jacc-spi.jar
    6.9KB
  • xstream-1.3.jar
    401.5KB
  • org.springframework.test-3.0.0.RELEASE.jar
    202.1KB
  • osdt_cert.jar
    187.3KB
  • org.springframework.transaction-3.0.0.RELEASE.jar
    226.2KB
  • spring-security-cas-client-3.0.1.RELEASE.jar
    18.9KB
  • jps-manifest.jar
    694B
  • slf4j-api-1.4.3.jar
    15KB
  • org.springframework.core-3.0.0.RELEASE.jar
    350.9KB
  • jsr250-api-1.0.jar
    5.7KB
  • org.springframework.asm-3.0.0.RELEASE.jar
    51.8KB
  • org.springframework.jdbc-3.0.0.RELEASE.jar
    372.9KB
  • fmw_audit.jar
    537.6KB
  • osdt_core.jar
    262.1KB
  • jps-unsupported-api.jar
    134.6KB
  • jmxremote_optional-1.0-b02.jar
    512.6KB
  • spring-security-acl-3.0.1.RELEASE.jar
    76.2KB
  • ldapjclnt11.jar
    1.6MB
  • jps-internal.jar
    2.9MB
  • org.springframework.context.support-3.0.0.RELEASE.jar
    98.8KB
  • jps-upgrade.jar
    556.8KB
  • org.springframework.aop-3.0.0.RELEASE.jar
    316.6KB
  • spring-security-config-3.0.1.RELEASE.jar
    156.5KB
  • org.springframework.expression-3.0.0.RELEASE.jar
    150.6KB
  • oraclepki.jar
    215.6KB
  • org.springframework.aspects-3.0.0.RELEASE.jar
    29.8KB
  • spring-security-core-3.0.1.RELEASE.jar
    297.8KB
  • jps-api.jar
    587.7KB
  • osdt_xmlsec.jar
    370.1KB
  • log4j-1.2.15.jar
    382.7KB
  • jagent.jar
    245.8KB
  • spring-security-web-3.0.1.RELEASE.jar
    224.4KB
  • org.springframework.context-3.0.0.RELEASE.jar
    642.1KB
  • slf4j-log4j12-1.4.3.jar
    8.4KB
内容介绍
/ Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved./ This is a User exit example for access to "Primary Key Updates" and "before images" from Updates. This example uses the PK_BF_TIMESRC and PK_BF_TIMETRG tables, which can be created using the demo_*pk_befores_create.sql scripts included with the ER release. This same script will add a stored procedure, which when executed will Insert and Update a row of data. Please be sure to "ADD TRANDATA" for the PK_BF_TIMESRC table for those databases which allow the GGSCI command, before executing. To compile this exit code, use the appropriate make or project file in this same directory. The compiles are 32bit, for 64bit, changes will be necessary in the make files as well as possibly #includes in the .c file. This example is a hypothetical business solution when a target database does not allow the Primary Key Updates. Therefore, when reading a PKUpdate record, it will change this operation into two separate records of Delete and Insert. While this is not necessary for most databases, for those databases which PKUpdates are not allow this example is not necessarily a recommended solution to this problem. It is only an example to demonstrate access to PKupdate records. This example will work for Extract and Replicat. This example will also show access to the before images of an Update. These records are typically included with the use of GETUPDATEBEFORES or the "cuserexit" option of INCLUDEUPDATEBEFORES. This is intended as a hypothetical business solution of conflict detection base on a specific column. The is an example which can only function in Replicat. The examples when used in a Replicat will also make use of the SQLEXEC functionality. Several user exit callbacks allow for access by both name or by index, examples are shown for both. Callbacks that are exercised GET_TABLE_NAME Used to get Name GET_ENV_VALUE Used to get ENV values same as GGS @GETENV() function GET_OPERATION_TYPE Used to test to only manipulate needed record types of UPDATE_COMP_SQL_VAL, UPDATE_COMP_PK_SQL_VAL SET_OPERATION_TYPE Used to change the current IO type GET_TABLE_COLUMN_COUNT Used to get number of column, number of key columns GET_TABLE_METADATA Used to get keys GET_BEFORE_AFTER_IND Used to get the type of record image GET_COLUMN_NAME_FROM_INDEX Used to get column name GET_COLUMN_VALUE_FROM_NAME Used to get column value GET_COLUMN_VALUE_FROM_INDEX Used to get column value SET_COLUMN_VALUE_BY_INDEX Used to set column value SET_COLUMN_VALUE_BY_NAME Used to set column value GET_ERROR_INFO Used to get error info OUTPUT_MESSAGE_TO_REPORT Used to write messages to report file ------------------------------------------------------------------------------------------------------------------------- Param file options with Extract using the User Exit (only for PKUpdate processing) Optional EXTRACT EXTPKUP EXTRACT EXTPUMP USERID XYZ, password XYZ PASSTHRU EXTTRAIL dirdat\ux EXTTRAIL dirdat\xu GETUPDATEBEFORES TABLE XYZ.*; --Next option is DB specific, -- this is for Oracle -- if the Extract is processing -- PKUpdates it must have a full -- image for Insert FETCHOPTIONS FETCHPKUPDATECOLS CUSEREXIT cuserexit.dll CUSEREXIT TABLE XYZ.PK_BF_TIMESRC; ------------------------------------------------------------------------------------------------------------------------- Param file options with Extract Pump using the User Exit (only for PKUpdate processing) EXTRACT EXTPKUP EXTRACT EXTPUMP USERID XYZ, password XYZ SOURCEDEFS dirdef\pk.def EXTTRAIL dirdat\ux EXTTRAIL dirdat\xu GETUPDATEBEFORES CUSEREXIT cuserexit.dll CUSEREXIT, INCLUDEUPDATEBEFORES -- if the Extract is processing TABLE XYZ.*; -- PKUpdates it must have a full -- image for Insert -- Next option is DB specific, -- plese check the manual as needed. FETCHOPTIONS FETCHPKUPDATECOLS TABLE XYZ.PK_BF_TIMESRC; ------------------------------ These Replicat params are for either of the first two examples with Extract processing the PKUpdate REPLICAT REPPKBF DISCARDFILE dirrpt\repdisc.txt, purge USERID XYZ, password XYZ ALLOWDUPTARGETMAP ASSUMETARGETDEFS CUSEREXIT cuserexit.dll CUSEREXIT, INCLUDEUPDATEBEFORES IGNOREINSERTS IGNOREDELETES MAP XYZ.PK_BF_TIMESRC, TARGET XYZ.PK_BF_TIMETRG, sqlexec (ID fetchUP, on update, trace all, error fatal, QUERY " select LAST_UPDATE_DATETIME from XYZ.PK_BF_TIMETRG " " where key_num = :key_num and cat_code = :cat_code and first_num_data_col = :first_num_data_col ", params (key_num = before.key_num, cat_code = before.cat_code, first_num_data_col = before.first_num_data_col) ) , colmap (usedefaults, LAST_UPDATE_DATETIME = @date ("YYYY-MM-DD:HH:MI:SS", "YYYY-MM-DD HH:MI:SS", fetchUP.LAST_UPDATE_DATETIME) ), filter ( @streq ( "SQL COMPUPDATE", @getenv ("GGHEADER", "OPTYPE") ) ) ; IGNOREUPDATES GETDELETES GETINSERTS MAP XYZ.PK_BF_TIMESRC, TARGET XYZ.PK_BF_TIMETRG; ------------------------------------------------------------------------------------------------------------------------- Param files options for Replicat using the User Exit. EXTRACT EXTPKUP USERID XYZ, password XYZ EXTTRAIL dirdat\ux GETUPDATEBEFORES TABLE XYZ.PK_BF_TIMESRC; ------------------------------ REPLICAT REPPKBF DISCARDFILE dirrpt\repdisc.txt, purge USERID XYZ, password XYZ ALLOWDUPTARGETMAP ASSUMETARGETDEFS CUSEREXIT cuserexit.dll CUSEREXIT, INCLUDEUPDATEBEFORES IGNOREINSERTS IGNOREDELETES MAP XYZ.PK_BF_TIMESRC, TARGET XYZ.PK_BF_TIMETRG, sqlexec (ID fetchPK, on update, trace all, error fatal, QUERY " select " " FIRST_VAR_DATA_COL , " " SECOND_VAR_DATA_COL, " " SECOND_NUM_DATA_COL, " " LAST_UPDATE_DATETIME " " FROM XYZ.PK_BF_TIMETRG " " where key_num = :key_num and cat_code = :cat_code and first_num_data_col = :first_num_data_col ", params (key_num = before.key_num, cat_code = before.cat_code, first_num_data_col = before.first_num_data_col) ) , colmap (usedefaults, FIRST_VAR_DATA_COL = fetchPK.FIRST_VAR_DATA_COL SECOND_VAR_DATA_COL = fetchPK.SECOND_VAR_DATA_COL SECOND_NUM_DATA_COL = fetchPK.SECOND_NUM_DATA_COL LAST_UPDATE_DATETIME = @date ("YYYY-MM-DD:HH:MI:SS", "YYYY-MM-DD HH:MI:SS", fetchPK.LAST_UPDATE_DATETIME) ) , filter ( @streq ( "PK UPDATE", @getenv ("GGHEADER", "OPTYPE") ) ) ; MAP XYZ.PK_BF_TIMESRC, TARGET XYZ.PK_BF_TIMETRG, sqlexec (ID fetchUP, on update, trace all, error
评论
    相关推荐
    • windows系统解析
      1.windows XP系统内核文件分析(全) 2.Windows2000XP系统文件夹详解 3.Windows下的EXE文件解析 4.WINDOWS常见文件夹完全解析 5.Windows文件解析——CWINDOWSsystem32driversetchosts 6.Windows系统文件解析 7.对...
    • Windows 基础
      Windows API 基础 Windows API 基础 Windows API 基础 Windows API 基础 Windows API 基础
    • Windows 3.1
      Windows 3.1 网站 下载 简单的
    • windows 计算器
      windows 自带的计算器。解压到c:\windows\system32下。直接windows键+r 调用calc命令运行。
    • windows95
      Windows95的
    • windows shell
      windows shell的中文翻译,对windows程序员很有用
    • Windows file
      Windows file Windows file
    • windows 窗体
      加载子窗体的源码,windows 窗体。
    • windows清理
      Microsoft 已更新了 Windows Installer 清理实用工具(Windows Installer CleanUp Utility ).利用 Windows Installer 清理实用工具,可以删除程序的 Windows Installer 配置信息.如果您遇到安装(安装程序)问题,可能...
    • windows api
      windows api资源,包括:Windows高级编程源代码 MFC中文帮助 vfp_api Windows程序设计