NT_OshWrapper.exe: cannot execute: command line too long
Posted: Sat Apr 12, 2014 8:27 pm
Have received following error messages. Anyone have any idea what is going on? Is it really that the tortilla is too big to eat?
Server:BIAPPPR04
Project:CVI
Job No:204
Job name:CV_SAL_ORDER_TYPE_DS
Invocation:CV_SAL_ORDER_TYPE_DS_BAAN_UK
Event Number:6644
Event type:Info
User:NT AUTHORITY\system
Timestamp:4/7/2014 7:32:20 PM
Message Id:IIS-DSTAGE-RUN-I-0123
Message:
Contents of phantom output file
E:/IBM/InformationServer/Server/DSEngine/bin/NT_OshWrapper.exe: cannot execute: command line too long
Server:BIAPPPR04
Project:CVI
Job No:204
Job name:CV_SAL_ORDER_TYPE_DS
Invocation:CV_SAL_ORDER_TYPE_DS_BAAN_UK
Event Number:6645
Event type:Fatal
User:NT AUTHORITY\system
Timestamp:4/7/2014 7:32:20 PM
Message Id:IIS-DSTAGE-RUN-E-0370
Message:
Error setting up internal communications (fifo \\.\pipe\CVI-RT_SC204-CV_SAL_ORDER_TYPE_DS.CV_SAL_ORDER_TYPE_DS_BAAN_UK) STATUS() 2
Server:BIAPPPR04
Project:CVI
Job No:204
Job name:CV_SAL_ORDER_TYPE_DS
Invocation:CV_SAL_ORDER_TYPE_DS_BAAN_UK
Event Number:6642
Event type:Info
User:NT AUTHORITY\system
Timestamp:4/7/2014 7:31:16 PM
Message Id:IIS-DSTAGE-RUN-I-0470
Message:
OSH script
# OSH / orchestrate script for Job CV_SAL_ORDER_TYPE_DS compiled at 08:15:23 21 OCT 2013
#################################################################
#### STAGE: Tfm_AddAuditCols_Direct
## Operator
transform
## Operator options
-flag run
-name 'V0S69_CV_SAL_ORDER_TYPE_DS_Tfm_AddAuditCols_Direct'
-argvalue 'DATA_SOURCE=[&"DATA_SOURCE"]'
## General options
[ident('Tfm_AddAuditCols_Direct'); jobmon_ident('Tfm_AddAuditCols_Direct')]
## Inputs
0< [] 'Src_SalesOrderData_Direct_Tbl:lnk_SrcTbl_Direct_In.v'
## Outputs
0> [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out.v'
;
#### STAGE: Tgt_Staging_Tbl.lnk_Tfm_Direct_Out_Part
## Operator
hash -key LEGACY_CODE -ci -key LEGACY_DESC -ci -key ORDER_TYPE_CODE -ci -key ORDER_TYPE_DESC -ci
## General options
[ident('Tgt_Staging_Tbl.lnk_Tfm_Direct_Out_Part')]
## Inputs
0< [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out.v'
## Outputs
0> [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out_Part.v'
;
#### STAGE: Tgt_Staging_Tbl.lnk_Tfm_Direct_Out_Sort
## Operator
tsort -key LEGACY_CODE -ci -asc -nulls first -key LEGACY_DESC -ci -asc -nulls first -key ORDER_TYPE_CODE -ci -asc -nulls first -key ORDER_TYPE_DESC -ci -asc -nulls first -unique -nonStable
## General options
[ident('Tgt_Staging_Tbl.lnk_Tfm_Direct_Out_Sort')]
## Inputs
0< [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out_Part.v'
## Outputs
0> [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out_Part_Sort.v'
;
#################################################################
#### STAGE: Tgt_Staging_Tbl
## Operator
pxbridge
## Operator options
-Orientation link
-XMLProperties '<?xml version=\'1.0\' encoding=\'UTF-16\'?><Properties version=\'1.1\'><Common><Context type=\'int\'>2</Context><Variant type=\'string\'>4.5</Variant><DescriptorVersion type=\'string\'>1.0</DescriptorVersion><PartitionType type=\'int\'>3</PartitionType><RCP type=\'int\'>0</RCP></Common><Connection><DataSource type=\'string\'><![CDATA[[&"TargetDB.ConnectionString"]]]></DataSource><Database type=\'string\'><![CDATA[[&"TargetDB.Database"]]]></Database><Username type=\'string\'><![CDATA[[&"TargetDB.Username"]]]></Username><Password type=\'string\'><![CDATA[[&"TargetDB.Password"]]]></Password><UseSeparateConnectionForTWT type=\'bool\'><![CDATA[[&"TargetDB.UseSeparateConnectionForTWT"]]]><Database type=\'string\'><![CDATA[[&"TargetDB.DatabaseTWT"]]]></Database><Username type=\'string\'><![CDATA[[&"TargetDB.UsernameTWT"]]]></Username><Password type=\'string\'><![CDATA[[&"TargetDB.PasswordTWT"]]]></Password></UseSeparateConnectionForTWT></Connection><Usage><WriteMode type=\'int\'><![CDATA[0]]></WriteMode><TableName modified=\'1\' type=\'string\'><![CDATA[[&"TGT_TBL_STG"]]]></TableName><EnableCaseSensitiveIDs type=\'bool\'><![CDATA[0]]></EnableCaseSensitiveIDs><TruncateColumnNames type=\'bool\'><![CDATA[0]]></TruncateColumnNames><SQL><DirectInsert type=\'bool\'><![CDATA[0]]></DirectInsert><EnableRecordOrdering collapsed=\'1\' type=\'bool\'><![CDATA[0]]></EnableRecordOrdering><CheckDuplicateRows collapsed=\'1\' type=\'bool\'><![CDATA[0]]></CheckDuplicateRows></SQL><TableAction modified=\'1\' type=\'int\'><![CDATA[3]]><GenerateTruncateStatement modified=\'1\' type=\'bool\'><![CDATA[0]]><FailOnError collapsed=\'1\' type=\'bool\'><![CDATA[1]]></FailOnError><ReadTruncateStatementFromFile type=\'bool\'><![CDATA[0]]></ReadTruncateStatementFromFile><TruncateStatement modified=\'1\' type=\'string\'><![CDATA[Delete from [&"TGT_TBL_STG"] Where DATA_SOURCE=\'[&"DATA_SOURCE"]\' And STATUS_TYPE=\'DIRECT SO TYPE\']]></TruncateStatement></GenerateTruncateStatement></TableAction><Session><SchemaReconciliation><UnmatchedLinkColumnAction type=\'int\'><![CDATA[1]]></UnmatchedLinkColumnAction><TypeMismatchAction modified=\'1\' type=\'int\'><![CDATA[0]]></TypeMismatchAction><UnmatchedTableColumnAction type=\'int\'><![CDATA[1]]></UnmatchedTableColumnAction><MismatchReportingAction modified=\'1\' type=\'int\'><![CDATA[2]]></MismatchReportingAction></SchemaReconciliation><TemporaryWorkTable collapsed=\'1\' type=\'int\'><![CDATA[0]]><DropTable type=\'bool\'><![CDATA[1]]></DropTable></TemporaryWorkTable><LoadOptions collapsed=\'1\'><ValidatePKs collapsed=\'1\' type=\'bool\'><![CDATA[0]]></ValidatePKs><GenerateStatistics collapsed=\'1\' type=\'bool\'><![CDATA[0]]></GenerateStatistics><MaxRejectCount type=\'int\'><![CDATA[1]]></MaxRejectCount></LoadOptions></Session><BeforeAfterSQL collapsed=\'1\' modified=\'1\' type=\'bool\'><![CDATA[0]]></BeforeAfterSQL></Usage></Properties >'
-connector '{
variant=\'4.5\',
library=ccnz,
version=1.0,
variantlist=\'V1;4.5::ccnz\',
versionlist=\'1.0\',
name=NetezzaConnector
}'
-target 0 '{
DSDescription={ORDER_TYPE_CODE=\'\<none\>
Searchable\? N \', ORDER_TYPE_DESC=\'\<none\>
Searchable\? N \', LEGACY_CODE=\'\<none\>
Searchable\? N \', LEGACY_DESC=\'\<none\>
Searchable\? N \', STATUS_TYPE=\'\<none\>
Searchable\? N \', SUBJECT_AREA=\'\<none\>
Searchable\? N \', SOURCE_KEY=\'\<none\>
Searchable\? N \', DATA_SOURCE=\'\<none\>
Searchable\? N \', INSERT_DT=\'\<none\>
Searchable\? N \'},
DSDisplayWidth={ORDER_TYPE_CODE=30, ORDER_TYPE_DESC=100, LEGACY_CODE=30, LEGACY_DESC=30, STATUS_TYPE=30, SUBJECT_AREA=30, SOURCE_KEY=50, DATA_SOURCE=10, INSERT_DT=26},
DSSQLType={ORDER_TYPE_CODE=-9, ORDER_TYPE_DESC=-9, LEGACY_CODE=-9, LEGACY_DESC=-9, STATUS_TYPE=12, SUBJECT_AREA=12, SOURCE_KEY=-9, DATA_SOURCE=12, INSERT_DT=11},
DSDerivation={ORDER_TYPE_CODE=\'vVOrderTypecode\', ORDER_TYPE_DESC=\'If TrimLeadingTrailing(lnk_SrcTbl_Direct_In\.t_dsca)\=\\\'\\\' Then \"UNSPECIFIED\" Else UpCase(TrimLeadingTrailing(lnk_SrcTbl_Direct_In\.t_dsca))\', LEGACY_CODE=\'vVOrderTypecode\', LEGACY_DESC=\'If TrimLeadingTrailing(lnk_SrcTbl_Direct_In\.t_dsca)\=\\\'\\\' Then \"UNSPECIFIED\" Else UpCase(TrimLeadingTrailing(lnk_SrcTbl_Direct_In\.t_dsca))\', STATUS_TYPE=\'\\\'DIRECT SO TYPE\\\'\', SUBJECT_AREA=\'\\\'SALES\\\'\', SOURCE_KEY=\'vVOrderTypecode\:\\\'\~\\\'\:DATA_SOURCE\', DATA_SOURCE=\'DATA_SOURCE\', INSERT_DT=\'CurrentTimestamp()\'},
DSSQLPrecision={ORDER_TYPE_CODE=15, ORDER_TYPE_DESC=60, LEGACY_CODE=15, LEGACY_DESC=60, STATUS_TYPE=30, SUBJECT_AREA=30, SOURCE_KEY=50, DATA_SOURCE=10, INSERT_DT=26},
DSSQLScale={INSERT_DT=6},
DSSchema=\'record
(
ORDER_TYPE_CODE\:nullable ustring\[max\=15\]\;
ORDER_TYPE_DESC\:nullable ustring\[max\=60\]\;
LEGACY_CODE\:nullable ustring\[max\=15\]\;
LEGACY_DESC\:nullable ustring\[max\=60\]\;
STATUS_TYPE\:nullable string\[max\=30\]\;
SUBJECT_AREA\:nullable string\[max\=30\]\;
SOURCE_KEY\:ustring\[max\=50\]\;
DATA_SOURCE\:string\[max\=10\]\;
INSERT_DT\:timestamp\;
)\'
}'
## General options
[ident('Tgt_Staging_Tbl'); jobmon_ident('Tgt_Staging_Tbl')]
## Inputs
0< [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out_Part_Sort.v'
;
#################################################################
#### STAGE: Src_SalesOrderData_Direct_Tbl
## Operator
pxbridge
## Operator options
-Orientation link
-XMLProperties '<?xml version=\'1.0\' encoding=\'UTF-16\'?><Properties version=\'1.1\'><Common><Context type=\'int\'>1</Context><Variant type=\'string\'>3.5</Variant><DescriptorVersion type=\'string\'>1.0</DescriptorVersion><PartitionType type=\'int\'>-1</PartitionType><RCP type=\'int\'>0</RCP></Common><Connection><DataSource modified=\'1\' type=\'string\'><![CDATA[[&"HostODBCCon.ConnectionString"]]]></DataSource><Username modified=\'1\' type=\'string\'><![CDATA[[&"HostODBCCon.Username"]]]></Username><Password modified=\'1\' type=\'string\'><![CDATA[[&"HostODBCCon.Password"]]]></Password></Connection><Usage><GenerateSQL type=\'bool\'><![CDATA[0]]></GenerateSQL><EnableQuotedIDs type=\'bool\'><![CDATA[0]]></EnableQuotedIDs><SQL><SelectStatement modified=\'1\' type=\'string\'><![CDATA[select
t_sotp,
t_dsca
from
ttdsls094[&"REG_CODE"]]]><ReadStatementFromFile type=\'bool\'><![CDATA[0]]></ReadStatementFromFile><Tables collapsed=\'1\'><Table type=\'string\'><![CDATA[ttdsls094[&"REG_CODE"]]]></Table></Tables><Parameters collapsed=\'1\'></Parameters><Columns collapsed=\'1\'><Column type=\'string\'><![CDATA[t_dsca,t_dsca,ttdsls094[&"REG_CODE"]]]></Column><Column type=\'string\'><![CDATA[t_sotp,t_sotp,ttdsls094[&"REG_CODE"]]]></Column></Columns></SelectStatement><EnablePartitioning collapsed=\'1\' type=\'bool\'><![CDATA[0]]></EnablePartitioning></SQL><Transaction><RecordCount type=\'int\'><![CDATA[2000]]></RecordCount><EndOfWave collapsed=\'1\' type=\'int\'><![CDATA[0]]></EndOfWave></Transaction><Session><IsolationLevel type=\'int\'><![CDATA[1]]></IsolationLevel><AutocommitMode type=\'int\'><![CDATA[0]]></AutocommitMode><ArraySize type=\'int\'><![CDATA[2000]]></ArraySize><SchemaReconciliation><FailOnSizeMismatch type=\'bool\'><![CDATA[1]]></FailOnSizeMismatch><FailOnTypeMismatch type=\'bool\'><![CDATA[1]]></FailOnTypeMismatch><FailOnCodePageMismatch type=\'bool\'><![CDATA[0]]></FailOnCodePageMismatch></SchemaReconciliation><PassLobLocator collapsed=\'1\' type=\'bool\'><![CDATA[0]]></PassLobLocator><CodePage collapsed=\'1\' type=\'int\'><![CDATA[0]]></CodePage></Session><BeforeAfter collapsed=\'1\' type=\'bool\'><![CDATA[0]]></BeforeAfter></Usage></Properties >'
-connector '{
variant=\'3.5\',
library=ccodbc,
version=1.0,
variantlist=\'V1;3.5::ccodbc\',
versionlist=\'1.0\',
name=ODBCConnector
}'
-source 0 '{
DSDescription={t_sotp=\'\<none\>
Searchable\? N \', t_dsca=\'\<none\>
Searchable\? N \'},
DSDisplayWidth={t_sotp=30, t_dsca=100},
DSSQLType={t_sotp=12, t_dsca=12},
DSSQLPrecision={t_sotp=10, t_dsca=60},
DSSchema=\'record
(
t_sotp\:string\[max\=10\]\;
t_dsca\:ustring\[max\=60\]\;
)\'
}'
## General options
[ident('Src_SalesOrderData_Direct_Tbl'); jobmon_ident('Src_SalesOrderData_Direct_Tbl')]
## Outputs
0> [modify (
t_sotp:not_nullable string[max=10]=t_sotp;
t_dsca:not_nullable ustring[max=60]=t_dsca;
keep
t_sotp,t_dsca;
)] 'Src_SalesOrderData_Direct_Tbl:lnk_SrcTbl_Direct_In.v'
;
# End of OSH code
Server:BIAPPPR04
Project:CVI
Job No:204
Job name:CV_SAL_ORDER_TYPE_DS
Invocation:CV_SAL_ORDER_TYPE_DS_BAAN_UK
Event Number:6644
Event type:Info
User:NT AUTHORITY\system
Timestamp:4/7/2014 7:32:20 PM
Message Id:IIS-DSTAGE-RUN-I-0123
Message:
Contents of phantom output file
E:/IBM/InformationServer/Server/DSEngine/bin/NT_OshWrapper.exe: cannot execute: command line too long
Server:BIAPPPR04
Project:CVI
Job No:204
Job name:CV_SAL_ORDER_TYPE_DS
Invocation:CV_SAL_ORDER_TYPE_DS_BAAN_UK
Event Number:6645
Event type:Fatal
User:NT AUTHORITY\system
Timestamp:4/7/2014 7:32:20 PM
Message Id:IIS-DSTAGE-RUN-E-0370
Message:
Error setting up internal communications (fifo \\.\pipe\CVI-RT_SC204-CV_SAL_ORDER_TYPE_DS.CV_SAL_ORDER_TYPE_DS_BAAN_UK) STATUS() 2
Server:BIAPPPR04
Project:CVI
Job No:204
Job name:CV_SAL_ORDER_TYPE_DS
Invocation:CV_SAL_ORDER_TYPE_DS_BAAN_UK
Event Number:6642
Event type:Info
User:NT AUTHORITY\system
Timestamp:4/7/2014 7:31:16 PM
Message Id:IIS-DSTAGE-RUN-I-0470
Message:
OSH script
# OSH / orchestrate script for Job CV_SAL_ORDER_TYPE_DS compiled at 08:15:23 21 OCT 2013
#################################################################
#### STAGE: Tfm_AddAuditCols_Direct
## Operator
transform
## Operator options
-flag run
-name 'V0S69_CV_SAL_ORDER_TYPE_DS_Tfm_AddAuditCols_Direct'
-argvalue 'DATA_SOURCE=[&"DATA_SOURCE"]'
## General options
[ident('Tfm_AddAuditCols_Direct'); jobmon_ident('Tfm_AddAuditCols_Direct')]
## Inputs
0< [] 'Src_SalesOrderData_Direct_Tbl:lnk_SrcTbl_Direct_In.v'
## Outputs
0> [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out.v'
;
#### STAGE: Tgt_Staging_Tbl.lnk_Tfm_Direct_Out_Part
## Operator
hash -key LEGACY_CODE -ci -key LEGACY_DESC -ci -key ORDER_TYPE_CODE -ci -key ORDER_TYPE_DESC -ci
## General options
[ident('Tgt_Staging_Tbl.lnk_Tfm_Direct_Out_Part')]
## Inputs
0< [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out.v'
## Outputs
0> [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out_Part.v'
;
#### STAGE: Tgt_Staging_Tbl.lnk_Tfm_Direct_Out_Sort
## Operator
tsort -key LEGACY_CODE -ci -asc -nulls first -key LEGACY_DESC -ci -asc -nulls first -key ORDER_TYPE_CODE -ci -asc -nulls first -key ORDER_TYPE_DESC -ci -asc -nulls first -unique -nonStable
## General options
[ident('Tgt_Staging_Tbl.lnk_Tfm_Direct_Out_Sort')]
## Inputs
0< [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out_Part.v'
## Outputs
0> [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out_Part_Sort.v'
;
#################################################################
#### STAGE: Tgt_Staging_Tbl
## Operator
pxbridge
## Operator options
-Orientation link
-XMLProperties '<?xml version=\'1.0\' encoding=\'UTF-16\'?><Properties version=\'1.1\'><Common><Context type=\'int\'>2</Context><Variant type=\'string\'>4.5</Variant><DescriptorVersion type=\'string\'>1.0</DescriptorVersion><PartitionType type=\'int\'>3</PartitionType><RCP type=\'int\'>0</RCP></Common><Connection><DataSource type=\'string\'><![CDATA[[&"TargetDB.ConnectionString"]]]></DataSource><Database type=\'string\'><![CDATA[[&"TargetDB.Database"]]]></Database><Username type=\'string\'><![CDATA[[&"TargetDB.Username"]]]></Username><Password type=\'string\'><![CDATA[[&"TargetDB.Password"]]]></Password><UseSeparateConnectionForTWT type=\'bool\'><![CDATA[[&"TargetDB.UseSeparateConnectionForTWT"]]]><Database type=\'string\'><![CDATA[[&"TargetDB.DatabaseTWT"]]]></Database><Username type=\'string\'><![CDATA[[&"TargetDB.UsernameTWT"]]]></Username><Password type=\'string\'><![CDATA[[&"TargetDB.PasswordTWT"]]]></Password></UseSeparateConnectionForTWT></Connection><Usage><WriteMode type=\'int\'><![CDATA[0]]></WriteMode><TableName modified=\'1\' type=\'string\'><![CDATA[[&"TGT_TBL_STG"]]]></TableName><EnableCaseSensitiveIDs type=\'bool\'><![CDATA[0]]></EnableCaseSensitiveIDs><TruncateColumnNames type=\'bool\'><![CDATA[0]]></TruncateColumnNames><SQL><DirectInsert type=\'bool\'><![CDATA[0]]></DirectInsert><EnableRecordOrdering collapsed=\'1\' type=\'bool\'><![CDATA[0]]></EnableRecordOrdering><CheckDuplicateRows collapsed=\'1\' type=\'bool\'><![CDATA[0]]></CheckDuplicateRows></SQL><TableAction modified=\'1\' type=\'int\'><![CDATA[3]]><GenerateTruncateStatement modified=\'1\' type=\'bool\'><![CDATA[0]]><FailOnError collapsed=\'1\' type=\'bool\'><![CDATA[1]]></FailOnError><ReadTruncateStatementFromFile type=\'bool\'><![CDATA[0]]></ReadTruncateStatementFromFile><TruncateStatement modified=\'1\' type=\'string\'><![CDATA[Delete from [&"TGT_TBL_STG"] Where DATA_SOURCE=\'[&"DATA_SOURCE"]\' And STATUS_TYPE=\'DIRECT SO TYPE\']]></TruncateStatement></GenerateTruncateStatement></TableAction><Session><SchemaReconciliation><UnmatchedLinkColumnAction type=\'int\'><![CDATA[1]]></UnmatchedLinkColumnAction><TypeMismatchAction modified=\'1\' type=\'int\'><![CDATA[0]]></TypeMismatchAction><UnmatchedTableColumnAction type=\'int\'><![CDATA[1]]></UnmatchedTableColumnAction><MismatchReportingAction modified=\'1\' type=\'int\'><![CDATA[2]]></MismatchReportingAction></SchemaReconciliation><TemporaryWorkTable collapsed=\'1\' type=\'int\'><![CDATA[0]]><DropTable type=\'bool\'><![CDATA[1]]></DropTable></TemporaryWorkTable><LoadOptions collapsed=\'1\'><ValidatePKs collapsed=\'1\' type=\'bool\'><![CDATA[0]]></ValidatePKs><GenerateStatistics collapsed=\'1\' type=\'bool\'><![CDATA[0]]></GenerateStatistics><MaxRejectCount type=\'int\'><![CDATA[1]]></MaxRejectCount></LoadOptions></Session><BeforeAfterSQL collapsed=\'1\' modified=\'1\' type=\'bool\'><![CDATA[0]]></BeforeAfterSQL></Usage></Properties >'
-connector '{
variant=\'4.5\',
library=ccnz,
version=1.0,
variantlist=\'V1;4.5::ccnz\',
versionlist=\'1.0\',
name=NetezzaConnector
}'
-target 0 '{
DSDescription={ORDER_TYPE_CODE=\'\<none\>
Searchable\? N \', ORDER_TYPE_DESC=\'\<none\>
Searchable\? N \', LEGACY_CODE=\'\<none\>
Searchable\? N \', LEGACY_DESC=\'\<none\>
Searchable\? N \', STATUS_TYPE=\'\<none\>
Searchable\? N \', SUBJECT_AREA=\'\<none\>
Searchable\? N \', SOURCE_KEY=\'\<none\>
Searchable\? N \', DATA_SOURCE=\'\<none\>
Searchable\? N \', INSERT_DT=\'\<none\>
Searchable\? N \'},
DSDisplayWidth={ORDER_TYPE_CODE=30, ORDER_TYPE_DESC=100, LEGACY_CODE=30, LEGACY_DESC=30, STATUS_TYPE=30, SUBJECT_AREA=30, SOURCE_KEY=50, DATA_SOURCE=10, INSERT_DT=26},
DSSQLType={ORDER_TYPE_CODE=-9, ORDER_TYPE_DESC=-9, LEGACY_CODE=-9, LEGACY_DESC=-9, STATUS_TYPE=12, SUBJECT_AREA=12, SOURCE_KEY=-9, DATA_SOURCE=12, INSERT_DT=11},
DSDerivation={ORDER_TYPE_CODE=\'vVOrderTypecode\', ORDER_TYPE_DESC=\'If TrimLeadingTrailing(lnk_SrcTbl_Direct_In\.t_dsca)\=\\\'\\\' Then \"UNSPECIFIED\" Else UpCase(TrimLeadingTrailing(lnk_SrcTbl_Direct_In\.t_dsca))\', LEGACY_CODE=\'vVOrderTypecode\', LEGACY_DESC=\'If TrimLeadingTrailing(lnk_SrcTbl_Direct_In\.t_dsca)\=\\\'\\\' Then \"UNSPECIFIED\" Else UpCase(TrimLeadingTrailing(lnk_SrcTbl_Direct_In\.t_dsca))\', STATUS_TYPE=\'\\\'DIRECT SO TYPE\\\'\', SUBJECT_AREA=\'\\\'SALES\\\'\', SOURCE_KEY=\'vVOrderTypecode\:\\\'\~\\\'\:DATA_SOURCE\', DATA_SOURCE=\'DATA_SOURCE\', INSERT_DT=\'CurrentTimestamp()\'},
DSSQLPrecision={ORDER_TYPE_CODE=15, ORDER_TYPE_DESC=60, LEGACY_CODE=15, LEGACY_DESC=60, STATUS_TYPE=30, SUBJECT_AREA=30, SOURCE_KEY=50, DATA_SOURCE=10, INSERT_DT=26},
DSSQLScale={INSERT_DT=6},
DSSchema=\'record
(
ORDER_TYPE_CODE\:nullable ustring\[max\=15\]\;
ORDER_TYPE_DESC\:nullable ustring\[max\=60\]\;
LEGACY_CODE\:nullable ustring\[max\=15\]\;
LEGACY_DESC\:nullable ustring\[max\=60\]\;
STATUS_TYPE\:nullable string\[max\=30\]\;
SUBJECT_AREA\:nullable string\[max\=30\]\;
SOURCE_KEY\:ustring\[max\=50\]\;
DATA_SOURCE\:string\[max\=10\]\;
INSERT_DT\:timestamp\;
)\'
}'
## General options
[ident('Tgt_Staging_Tbl'); jobmon_ident('Tgt_Staging_Tbl')]
## Inputs
0< [] 'Tfm_AddAuditCols_Direct:lnk_Tfm_Direct_Out_Part_Sort.v'
;
#################################################################
#### STAGE: Src_SalesOrderData_Direct_Tbl
## Operator
pxbridge
## Operator options
-Orientation link
-XMLProperties '<?xml version=\'1.0\' encoding=\'UTF-16\'?><Properties version=\'1.1\'><Common><Context type=\'int\'>1</Context><Variant type=\'string\'>3.5</Variant><DescriptorVersion type=\'string\'>1.0</DescriptorVersion><PartitionType type=\'int\'>-1</PartitionType><RCP type=\'int\'>0</RCP></Common><Connection><DataSource modified=\'1\' type=\'string\'><![CDATA[[&"HostODBCCon.ConnectionString"]]]></DataSource><Username modified=\'1\' type=\'string\'><![CDATA[[&"HostODBCCon.Username"]]]></Username><Password modified=\'1\' type=\'string\'><![CDATA[[&"HostODBCCon.Password"]]]></Password></Connection><Usage><GenerateSQL type=\'bool\'><![CDATA[0]]></GenerateSQL><EnableQuotedIDs type=\'bool\'><![CDATA[0]]></EnableQuotedIDs><SQL><SelectStatement modified=\'1\' type=\'string\'><![CDATA[select
t_sotp,
t_dsca
from
ttdsls094[&"REG_CODE"]]]><ReadStatementFromFile type=\'bool\'><![CDATA[0]]></ReadStatementFromFile><Tables collapsed=\'1\'><Table type=\'string\'><![CDATA[ttdsls094[&"REG_CODE"]]]></Table></Tables><Parameters collapsed=\'1\'></Parameters><Columns collapsed=\'1\'><Column type=\'string\'><![CDATA[t_dsca,t_dsca,ttdsls094[&"REG_CODE"]]]></Column><Column type=\'string\'><![CDATA[t_sotp,t_sotp,ttdsls094[&"REG_CODE"]]]></Column></Columns></SelectStatement><EnablePartitioning collapsed=\'1\' type=\'bool\'><![CDATA[0]]></EnablePartitioning></SQL><Transaction><RecordCount type=\'int\'><![CDATA[2000]]></RecordCount><EndOfWave collapsed=\'1\' type=\'int\'><![CDATA[0]]></EndOfWave></Transaction><Session><IsolationLevel type=\'int\'><![CDATA[1]]></IsolationLevel><AutocommitMode type=\'int\'><![CDATA[0]]></AutocommitMode><ArraySize type=\'int\'><![CDATA[2000]]></ArraySize><SchemaReconciliation><FailOnSizeMismatch type=\'bool\'><![CDATA[1]]></FailOnSizeMismatch><FailOnTypeMismatch type=\'bool\'><![CDATA[1]]></FailOnTypeMismatch><FailOnCodePageMismatch type=\'bool\'><![CDATA[0]]></FailOnCodePageMismatch></SchemaReconciliation><PassLobLocator collapsed=\'1\' type=\'bool\'><![CDATA[0]]></PassLobLocator><CodePage collapsed=\'1\' type=\'int\'><![CDATA[0]]></CodePage></Session><BeforeAfter collapsed=\'1\' type=\'bool\'><![CDATA[0]]></BeforeAfter></Usage></Properties >'
-connector '{
variant=\'3.5\',
library=ccodbc,
version=1.0,
variantlist=\'V1;3.5::ccodbc\',
versionlist=\'1.0\',
name=ODBCConnector
}'
-source 0 '{
DSDescription={t_sotp=\'\<none\>
Searchable\? N \', t_dsca=\'\<none\>
Searchable\? N \'},
DSDisplayWidth={t_sotp=30, t_dsca=100},
DSSQLType={t_sotp=12, t_dsca=12},
DSSQLPrecision={t_sotp=10, t_dsca=60},
DSSchema=\'record
(
t_sotp\:string\[max\=10\]\;
t_dsca\:ustring\[max\=60\]\;
)\'
}'
## General options
[ident('Src_SalesOrderData_Direct_Tbl'); jobmon_ident('Src_SalesOrderData_Direct_Tbl')]
## Outputs
0> [modify (
t_sotp:not_nullable string[max=10]=t_sotp;
t_dsca:not_nullable ustring[max=60]=t_dsca;
keep
t_sotp,t_dsca;
)] 'Src_SalesOrderData_Direct_Tbl:lnk_SrcTbl_Direct_In.v'
;
# End of OSH code