Altbestand iwm_articles_tkz_6_scheuertouren

Definition prüfen

Raw YAML Metadaten

engine Typ

valid Parse-Status

Managed Status

draft

importEngine Kurzinfo

Raw YAML

Dateiinhalt

Engine: Import
Source_Config: oster400
Target_Config: importEngine
Mysql_Engine: InnoDB
Default_Charset: latin1
Source_Connection_Type: database
Source_Database_Connection_Service: DatabaseConnectionService

Queries:
 - Query:
     GetQuery: SELECT Right(Left(TRIM(TXKEYD),LENGTH (TRIM(TXKEYD))-7),1) AS FIRMA, Right(TRIM(TXKEYD),LENGTH (TRIM(TXKEYD))-3) AS ordernumber, TRIM(T3ZTXT) AS properties
                              FROM IWMV2R1DTA.TXHD00 INNER JOIN IWMV2R1DTA.TX4000 ON (IWMV2R1DTA.TXHD00.TXTXNR = IWMV2R1DTA.TX4000.T3TXNR) AND (IWMV2R1DTA.TXHD00.TXTXTY = IWMV2R1DTA.TX4000.T3TXTY)
                              WHERE TXSTAT='A' AND TXDTNM='ARTS00' AND T3STAT='A'
                              GROUP BY Right(Left(TRIM(TXKEYD),LENGTH (TRIM(TXKEYD))-7),1), Right(TRIM(TXKEYD),LENGTH(TRIM(TXKEYD))-3), TRIM(T3ZTXT), IWMV2R1DTA.TX4000.T3TBVW



     TargetDatapool: iwm_articles_tkz_6_all

Metadata

Erkannte Konfiguration

Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.

Engine	Import
Source_Config	oster400
Target_Config	importEngine
Mysql_Engine	InnoDB
Default_Charset	latin1
Source_Connection_Type	database
Source_Database_Connection_Service	DatabaseConnectionService
Queries	[ { "Query": { "GetQuery": "SELECT Right(Left(TRIM(TXKEYD),LENGTH (TRIM(TXKEYD))-7),1) AS FIRMA, Right(TRIM(TXKEYD),LENGTH (TRIM(TXKEYD))-3) AS ordernumber, TRIM(T3ZTXT) AS properties FROM IWMV2R1DTA.TXHD00 INNER JOIN IWMV2R1DTA.TX4000 ON (IWMV2R1DTA.TXHD00.TXTXNR = IWMV2R1DTA.TX4000.T3TXNR) AND (IWMV2R1DTA.TXHD00.TXTXTY = IWMV2R1DTA.TX4000.T3TXTY) WHERE TXSTAT='A' AND TXDTNM='ARTS00' AND T3STAT='A' GROUP BY Right(Left(TRIM(TXKEYD),LENGTH (TRIM(TXKEYD))-7),1), Right(TRIM(TXKEYD),LENGTH(TRIM(TXKEYD))-3), TRIM(T3ZTXT), IWMV2R1DTA.TX4000.T3TBVW", "TargetDatapool": "iwm_articles_tkz_6_all" } } ]