Hi Rex,
Think you possible responded to the wrong thread with this response?
Thank
Attila
------------------------------
Attila Toke
------------------------------
Original Message:
Sent: Tue December 06, 2022 12:17 PM
From: Rex Chan
Subject: ITX - split file using control-break logic
Not sure about your rule, Try this, if it doesn't work, post the adapter trace here. It has an extension of dbl.
= VALID(GET("DB",
" -MDQ name.mdq -DBNAME %db2_service% -STMT ' insert into tablename values (" +In1+") -T+"),
FAIL("Failed to perform database operation, Error Code: "+LASTERRORCODE()+" – Error Message: "+LASTERRORMSG()))
------------------------------
Rex Chan
Original Message:
Sent: Tue December 06, 2022 08:51 AM
From: Attila Toke
Subject: ITX - split file using control-break logic
Hi Paul,
Thanks, however, I cannot seem to find an example. Even looking here ITX Pack for Supply Chain EDI - IBM Documentation
if someone sees it and can point it out to me that would be helpful, it is probably right in front of my face..
Thanks
Attila
------------------------------
Attila Toke
Original Message:
Sent: Tue December 06, 2022 08:04 AM
From: Paul Brett
Subject: ITX - split file using control-break logic
As I understand it, the Examples would only be available for the full EDI Pack loaded on a Windows system.
Thank you.
------------------------------
Paul Brett
IBM Sterling Transformation Extender (ITX) Client Support
Original Message:
Sent: Tue December 06, 2022 07:40 AM
From: Attila Toke
Subject: ITX - split file using control-break logic
Hi Paul,
Appreciate the quick reply. can you provide the default path to where these would be so I can try and see if we have the examples loaded in our system. I know we have the EDIPACK on our LINUX servers.
Thanks
Attila
------------------------------
Attila Toke
Original Message:
Sent: Tue December 06, 2022 07:26 AM
From: Paul Brett
Subject: ITX - split file using control-break logic
I believe that the ITX Pack for EDI will have examples of doing just this.
Thank you.
------------------------------
Paul Brett
IBM Sterling Transformation Extender (ITX) Client Support
Original Message:
Sent: Tue December 06, 2022 07:19 AM
From: Attila Toke
Subject: ITX - split file using control-break logic
Hello,
Are there any examples that will take a single EDI Interchange (ISA) with multiple transaction sets (ST) and generate a separate ISA for each transaction set (ST)?
We have some customers that cannot handle large EDI files so we need to break up the ISA by ST's.
Thanks
Attila
------------------------------
Attila Toke
Original Message:
Sent: Wed April 29, 2020 03:31 AM
From: Paul Brett
Subject: ITX - split file using control-break logic
Here's an example that splits based on a fixed quantity in the input.
------------------------------
Paul Brett
IBM Sterling Transformation Extender (ITX) Client Support
Original Message:
Sent: Tue April 28, 2020 11:45 AM
From: RM
Subject: ITX - split file using control-break logic
Hello @Paul Brett, can you please share the example "to split files into multiple files using ITX is by using the control-break category."?
Problem we are facing is with large EDI file, and I am trying to figure out best way to split large file into smaller files. I did raise a PMR and I was advised to post a question here.
Thank you!
------------------------------
Apache 47
------------------------------
#SupplyChain
#B2BIntegration