BIG fixed file input test /home/matt/test-stuff/Fixed Input Test.ktr 0 / YN
0.0 0.0 10000 100 100 N N 5000 N Schema-1 P1 P2 N Schema-2 2-1 2-2 N localhost:8084localhost8084clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N localhost:8083localhost8083clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N localhost:8082localhost8082clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N localhost:8081localhost8081clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N localhost:8080:Masterlocalhost8080clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8Y localhost:8080localhost8080clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N local schema 40000 2000 5000 N localhost:8080:Master localhost:8081 localhost:8082 - 2007/07/06 17:30:30.615 PGSQL Localhost test localhost POSTGRESQL Native test 5432 matt Encrypted 2be98afc86aa7f2e4cb79ce10df90acde CLUSTER_DBNAME_0db1 CLUSTER_DBNAME_1db2 CLUSTER_DBNAME_2db3 CLUSTER_DBNAME_3db4 CLUSTER_DBNAME_4db5 CLUSTER_HOSTNAME_0192.168.1.10 CLUSTER_HOSTNAME_1192.168.1.10 CLUSTER_HOSTNAME_2192.168.1.10 CLUSTER_HOSTNAME_3192.168.1.10 CLUSTER_HOSTNAME_4192.168.1.10 CLUSTER_PARTITION_0PartDB1 CLUSTER_PARTITION_1PartDB2 CLUSTER_PARTITION_2PartDB3 CLUSTER_PARTITION_3PartDB4 CLUSTER_PARTITION_4PartDB5 CLUSTER_PASSWORD_0Encrypted CLUSTER_PASSWORD_1Encrypted CLUSTER_PASSWORD_2Encrypted CLUSTER_PASSWORD_3Encrypted CLUSTER_PASSWORD_4Encrypted CLUSTER_PORT_03306 CLUSTER_PORT_13306 CLUSTER_PORT_23306 CLUSTER_PORT_33306 CLUSTER_PORT_43306 CUSTOM_DRIVER_CLASScom.ibm.u2.jdbc.UniJDBCDriver CUSTOM_URLjdbc:universe://localhost/database EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.rewriteBatchedStatementsfalse EXTRA_OPTION_MYSQL.useCursorFetchtrue EXTRA_OPTION_MYSQL.zeroDateTimeBehaviorconvertToNull EXTRA_OPTION_SYBASE.SQLINITSTRINGSET CHAINED OFF FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN INITIAL_POOL_SIZE5 IS_CLUSTEREDN MAXIMUM_POOL_SIZE10 MSSQL_DOUBLE_DECIMAL_SEPARATORN POOLING_defaultCatalogcatalog POOLING_removeAbandonedtrue POOLING_testOnReturnfalse PORT_NUMBER5432 QUOTE_ALL_FIELDSN STREAM_RESULTSY USE_POOLINGN MySQL localhost test localhost MYSQL Native test 3306 matt Encrypted 2be98afc86aa7f2e4cb79ce10df90acde CLUSTER_DBNAME_0db1 CLUSTER_DBNAME_1db2 CLUSTER_DBNAME_2db3 CLUSTER_DBNAME_3db4 CLUSTER_DBNAME_4db5 CLUSTER_HOSTNAME_0192.168.1.10 CLUSTER_HOSTNAME_1192.168.1.10 CLUSTER_HOSTNAME_2192.168.1.10 CLUSTER_HOSTNAME_3192.168.1.10 CLUSTER_HOSTNAME_4192.168.1.10 CLUSTER_PARTITION_0PartDB1 CLUSTER_PARTITION_1PartDB2 CLUSTER_PARTITION_2PartDB3 CLUSTER_PARTITION_3PartDB4 CLUSTER_PARTITION_4PartDB5 CLUSTER_PASSWORD_0Encrypted CLUSTER_PASSWORD_1Encrypted CLUSTER_PASSWORD_2Encrypted CLUSTER_PASSWORD_3Encrypted CLUSTER_PASSWORD_4Encrypted CLUSTER_PORT_03306 CLUSTER_PORT_13306 CLUSTER_PORT_23306 CLUSTER_PORT_33306 CLUSTER_PORT_43306 CUSTOM_DRIVER_CLASScom.ibm.u2.jdbc.UniJDBCDriver CUSTOM_URLjdbc:universe://localhost/database EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.rewriteBatchedStatementsfalse EXTRA_OPTION_MYSQL.useCursorFetchtrue EXTRA_OPTION_MYSQL.zeroDateTimeBehaviorconvertToNull EXTRA_OPTION_SYBASE.SQLINITSTRINGSET CHAINED OFF INITIAL_POOL_SIZE5 IS_CLUSTEREDN MAXIMUM_POOL_SIZE10 MSSQL_DOUBLE_DECIMAL_SEPARATORN POOLING_defaultCatalogcatalog POOLING_removeAbandonedtrue POOLING_testOnReturnfalse PORT_NUMBER3306 QUOTE_ALL_FIELDSN STREAM_RESULTSY USE_POOLINGN Fixed file inputDummy (do nothing)Y Dummy (do nothing) Dummy Y 1 none 495 65 Y Fixed file input FixedInput Y 1 none none /tmp/${Internal.Step.CopyNr}/bigfixed.txt 1529
N
1000000 Y N Y id Integer 0 none 10 8 0 field001 String none 10 10 -1 field002 String none 10 10 -1 field003 String none 10 10 -1 field004 String none 10 10 -1 field005 String none 10 10 -1 field006 String none 10 10 -1 field007 String none 10 10 -1 field008 String none 10 10 -1 field009 String none 10 10 -1 field010 String none 10 10 -1 field011 String none 10 10 -1 field012 String none 10 10 -1 field013 String none 10 10 -1 field014 String none 10 10 -1 field015 String none 10 10 -1 field016 String none 10 10 -1 field017 String none 10 10 -1 field018 String none 10 10 -1 field019 String none 10 10 -1 field020 String none 10 10 -1 field021 String none 10 10 -1 field022 String none 10 10 -1 field023 String none 10 10 -1 field024 String none 10 10 -1 field025 String none 10 10 -1 field026 String none 10 10 -1 field027 String none 10 10 -1 field028 String none 10 10 -1 field029 String none 10 10 -1 field030 String none 10 10 -1 field031 String none 10 10 -1 field032 String none 10 10 -1 field033 String none 10 10 -1 field034 String none 10 10 -1 field035 String none 10 10 -1 field036 String none 10 10 -1 field037 String none 10 10 -1 field038 String none 10 10 -1 field039 String none 10 10 -1 field040 String none 10 10 -1 field041 String none 10 10 -1 field042 String none 10 10 -1 field043 String none 10 10 -1 field044 String none 10 10 -1 field045 String none 10 10 -1 field046 String none 10 10 -1 field047 String none 10 10 -1 field048 String none 10 10 -1 field049 String none 10 10 -1 field050 String none 10 10 -1 field051 Integer 0 none 10 8 0 field052 Integer 0 none 10 8 0 field053 Integer 0 none 10 8 0 field054 Integer 0 none 10 8 0 field055 Integer 0 none 10 8 0 field056 Integer 0 none 10 8 0 field057 Integer 0 none 10 8 0 field058 Integer 0 none 10 8 0 field059 Integer 0 none 10 8 0 field060 Integer 0 none 10 8 0 field061 Integer 0 none 10 8 0 field062 Integer 0 none 10 8 0 field063 Integer 0 none 10 8 0 field064 Integer 0 none 10 8 0 field065 Integer 0 none 10 8 0 field066 Integer 0 none 10 8 0 field067 Integer 0 none 10 8 0 field068 Integer 0 none 10 8 0 field069 Integer 0 none 10 8 0 field070 Integer 0 none 10 8 0 field071 Integer 0 none 10 8 0 field072 Integer 0 none 10 8 0 field073 Integer 0 none 10 8 0 field074 Integer 0 none 10 8 0 field075 Integer 0 none 10 8 0 field076 Integer 0 none 10 8 0 field077 Integer 0 none 10 8 0 field078 Integer 0 none 10 8 0 field079 Integer 0 none 10 8 0 field080 Integer 0 none 10 8 0 field081 Integer 0 none 10 8 0 field082 Integer 0 none 10 8 0 field083 Integer 0 none 10 8 0 field084 Integer 0 none 10 8 0 field085 Integer 0 none 10 8 0 field086 Integer 0 none 10 8 0 field087 Integer 0 none 10 8 0 field088 Integer 0 none 10 8 0 field089 Integer 0 none 10 8 0 field090 Integer 0 none 10 8 0 field091 Integer 0 none 10 8 0 field092 Integer 0 none 10 8 0 field093 Integer 0 none 10 8 0 field094 Integer 0 none 10 8 0 field095 Integer 0 none 10 8 0 field096 Integer 0 none 10 8 0 field097 Integer 0 none 10 8 0 field098 Integer 0 none 10 8 0 field099 Integer 0 none 10 8 0 field100 Integer 0 none 10 8 0 field101 String none 10 10 -1 field102 String none 10 10 -1 field103 String none 10 10 -1 field104 String none 10 10 -1 field105 String none 10 10 -1 field106 String none 10 10 -1 field107 String none 10 10 -1 field108 String none 10 10 -1 field109 String none 10 10 -1 field110 String none 10 10 -1 field111 String none 10 10 -1 field112 String none 10 10 -1 field113 String none 10 10 -1 field114 String none 10 10 -1 field115 String none 10 10 -1 field116 String none 10 10 -1 field117 String none 10 10 -1 field118 String none 10 10 -1 field119 String none 10 10 -1 field120 String none 10 10 -1 field121 String none 10 10 -1 field122 String none 10 10 -1 field123 String none 10 10 -1 field124 String none 10 10 -1 field125 String none 10 10 -1 field126 String none 10 10 -1 field127 String none 10 10 -1 field128 String none 10 10 -1 field129 String none 10 10 -1 field130 Number 0 none 10 10 2 field131 Number none 10 10 2 field132 Number none 10 10 2 field133 Number none 10 10 2 field134 Number none 10 10 2 field135 Number none 10 10 2 field136 Number none 10 10 2 field137 Number none 10 10 2 field138 Number none 10 10 2 field139 Number none 10 10 2 field140 Number none 10 10 2 field141 Number none 10 10 2 field142 Number none 10 10 2 field143 Number none 10 10 2 field144 Number none 10 10 2 field145 Number none 10 10 2 field146 Number none 10 10 2 field147 Number none 10 10 2 field148 Number none 10 10 2 field149 Number none 10 10 2 field150 Number none 10 10 2 dateField Date yyyy-MM-dd HH:mm:ss none 19 -1 -1 271 65 Y
N