We Initialized job "A" and VersionControl moved job "B" (Sequencer job). We opened a case with Ascential. They said they could not reproduce the error and kind of quite from then. We happend to hit the same problem again now, after few months that happened. This time , we moved j...
how are updates in 7.5 version on an oracle table , for 300 thousand rows, is it good way to choose datastage or is it better to user oracle plsql , we are preferring to use datastage what do you say. Can any one help with suggestions Its better to use DataStage. DataStage seems to perform better. ...
roy wrote:Hi,
recently there was another post which also addressed the difference in maintaining and migrating those project variables between projects.
another thing effecting your decision.
Thanks for every one , for all the valuable suggestions.
We defined DataSourceName,DatabaseUserName,DatabasePassword and ------ so many other things as JobParameters and using them in our jobs. Is it advisable to use DataSourceName,DatabaseUserName,DatabasePassword and ------ so many other things as Environment variables and use them in the job, for Produ...
We have intialized a JobControl Job(JC_XYZ) from our Development region to VERSION project. The Version Control tool initialized entirely different job(Sequencer job), than what we intialized. All the previous 5 versions of the same job in the VERSION project are good. The latest version of the job ...
We are running these jobs in Production. At one point these jobs ran fine in development, but are failing in Production. Can any body guide us to solve this issue. JobDesign1 : SeqFile --->stgTransformer1-----> SeqFile --->stgTransformer2 ----> stgTransformer1 & stgTransformer2 ----> LinkCollect...
Yes, do a command line FTP in binary and you get a 100% bit-perfect match of the file. Anything else is open to interpretation by the processes conducting the transfer. Thanks Kenneth for your valuable opinions. What about the FTP from DataStage Server to MainFrame? We have some jobs which FTP text...
Write a .bat file that invokes ftp. If you have a scripting language or interpreter like MKS toolkit, you can use that. Or, you can write a DS BASIC Batch job and use DS to do the FTP, all you'll do is run FTP using the DSExecute API. Simply open a DOS prompt box and type ftp, you'll see that it is...
Folks, remember, the FTP stage is a READER, it reads the data file and sends data as rows across the network connection. Command line FTP doesn't CARE about the file, it transfer it in BLOCKS of data. You should NOT use the FTP stage as a file mover. This is like using a hammer to put screws into w...
The DataStage ftp stage calls the underlying FTP connection between your server and the remote machine. Hence it must be reliable. I got a chuckle from Sainath's comment as well; but I think it just came out differently from what he'd intended. I have made a hobby in the past years of baiting the 4...
There can be several reasons. Some are 1.) Lines contain special characters - such as Unix kill character - that restricts the display 2.) Record obtained from Data file which had an associated index. By default, COBOL enters null values over the record it deletes. This is generally corrected by pr...
Hi, We are trying to do a FTP from MainFrame to DataStage server. FTPStage --->Transformer ---->SequentailStage. We have set the following properties: RemotePath (left blank) RemoteFileName #parmFileName# DataRepresentation Ascii check data against meta data no line termination CR/LF Fixedwidth colu...