flat file

Dear All, Is it possible to setup Flat File Encoding in table triggers? I am goning to do some file operations on table data change. I think in P93081 it can not be set up. Thank you in advance Zoltan

Hi everyone , I need help.I want to use an UBE to read an XML as a flat file , and by using Fetch next Line from flat file , cut a substring between the <MS1:MsgId> to </MS1:MsgId> for example , and store it in a custom table , already built to match the type of the data we are going to...

Hi Customer uses the Amazon S3 buckets ( .csv / .txt) to store bank files. We need to read and upload them in JDE. I tried to used the FetchNextLineFromFlatFile (B76B0220) function but it fails. Checked the debuglog and it gives the 3003 error code (Open of File Unsuccessful). The files / S3...

Hi I created a flat file in my C drive as C:/file.txt and sending the same to my report through PO. and I debugged the report. while the B34A1010 (Open Flat file) function is working correctly and getting a file pointer. then the function B76B0220 (fetch next line from fat file)is called and...

Hi - I am trying to convert an inbound 850 flatfile using R47002C. The format is set up to go into F47011 and F47012. The delimiters are a comma (,) to separate fields and an apostrophe (" ") to delimit text. If anyone has resolved this problem and you please let me know how you resolved the...

Hello guys. I would like to know if using a cache structure, to write lines to a flat file in it, would be faster than stopping the application flow to wirte one line to flat file and get back to the application to process it again. So, if I "cache" the lines within the Do Section, in my...

Hello guys. I would like to know if using a cache structure, to write lines to a flat file in it, would be faster than stopping the application flow to wirte one line to flat file and get back to the application to process it again. So, if I "cache" the lines within the Do Section, in my report...

Hi all! Does anyone have an example of flatfile format that can be used to import into F3460Z1 forecast interop table using R47002C? I've read all documents i could find and have a file that should work but am "getting invalid format error" Attached is one of the files i've used. It's just...

Hi Guys, We are starting to work with SPS commerce for out EDI business. Recently they provided 850 layout, which was in single quote as double quote as qualifiers with LineFeed (LF) on the end. The problem with such a text file is that it doesn't specify whether each line is Header/Detiail or...