BIG fixed file input test
/home/matt/test-stuff/Fixed Input Test.ktr
0
/
Y
N
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
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