DSXchange

Thanks for replies. My understanding then is that the SOA tool could be used to enhance the Web interface with the Oracle tables once the data is loaded. There are DBA's that own and maintain the tables. The applications that access the Oracle tables are maintained at a different site and I'll get m...

My company currently loads data nightly to Oracle tables that are then accessed via Web applications. The data flows into the Oracle tables via mainframe processes from VSAM and DataStage Server edition jobs from Datacom. The processes above run in batch and the data is always a day behind. We also ...

Tech Support has resolved. The DataStage server is connected to LParA and LParA was connected to LParC via a router. DataStage is not the problem but rather the connection from A to C was causing the performance issue. Rather than connecting A and C via a router the connection was changed to the sys...

My company is in the process of moving TEST & STAGE databases to their own LPar's. Our DB is Datacom and recently TEST has been moved to LParC, STAGE and PROD are still on the same LPar. The next step is to move STAGE to LParB but it is being held up because of a DStage performance problem acces...

Thanks Craig. The FTP works perfectly.

Richard.

Attempting to FTP a file to the mainframe I encountered a problem with fields being Right Justified. Searches of the forum seemed to have one common resolution - FTP from the command line. Worked perfectly - thanks. If it's possible I would still like to FTP directly from DS to the Mainframe. Aside ...

Thanks. The field function worked very nicely. The fields are populating in the correct order. Remaining issue with justified right appears to be tied to how the FTP Plug-in is set up. When I write to a sequential file the data is left justified as expected. I will close this thread and search the F...

Code is CONVERT(CHAR(251),"",FMT(L1.ORG_NM,"25T")) I've tried TrimF(CONVERT(CHAR(251),"",FMT(L1.ORG_NM,"25T"))) and also using TrimF on the field in a second transform. Probably not a great idea but... I also tried to evaluate the field 25 bytes at a time but ...

Thanks Ray. The text mark and convert worked but with one problem. Names are left justified within each field but the fields are being filled from LAST to FIRST. I would have expected the opposite. Dicks Diner is " ", " ", "Dicks Diner " instead of "Dicks Diner &qu...

Thanks Ray.

I'll have to join to see the full reply but I get where you're going. I didn't think this was going to be more difficult than Cobol - nothing else in DS is.

Great forum! If the company won't kick in the $ I'll join myself.

Thanks again.
Richard

I put this in a resolved topic and probably shouldn't have. I have a 75 byte field that needs to be split into 3 smaller fields, 25 bytes each. Business rules require that none of the words be split in the middle and that each field begin with a character other than space . Input THE HAPPENING STUDI...