DSXchange

Thanks for all your comments. I was able to solve it.

I gave the Demiliter to be a 'tab' and the Quote character to be nothing. I got the output as needed; as each column written in each cell.

Hi, I'm trying to write output data to a spreadsheet as a .csv file using Sequential File stage. When I view the output spreadsheet, I see that the entire row is in the first cell. But I want it to be written in such a way that each column is in each cell of the spreadsheet. Please let me know what ...

DSguru2B,

The condition that I mean here is not a simple one, but its some complex conditions also involving join with some other table. Also this condition has to be implemented in DS as part of my application. So, I cannot ask the Mainframe folks to do it. Thats the scenario

Ray, I do not actually require all those millions of records for my processing. I only need some of those records based on a condition. So, I thought if there is some way I could directly extract those records from the Mainframe system itself, then I could filter only those records that I need by ap...

Hi, We are working in DS 7.1 version Server Job and the server OS in Windows. We have a scenario where we need to read a hugh file from the Mainframe system and then process it. - We cannot use a CFF stage to read this Mainframe file as it is in a remote Mainframe machine. So, we have use a FTP stag...

Yeah, this is the only 'named pipe' I'm using in the project.

Hi,

I'm trying to write to a Sequential File stage that is declared as a named pipe. The error that I get is,

ds_seqopen() - Win32 error in CreateFile - All pipe instances are busy.

Please let me know if anyone have solution for this.

Thanks.

asitagrawal, Can you please let me know the tool that you are using to move file from Mainframe to Windows server. You say that once the file is in the Windows server, it can be read using a Sequential File stage. But what is the metadata that you would give in this Sequential File stage. Because th...

ArndW,

As per you say, then what should be the metadata that needs to be given in the first FTP stage.

Hi, I need to read a Maifnrame file from a Mainframe server. Hope the only option is to use a FTP stage. Because, upon using the Complex Flat File stage, the file to be accessed has to reside in the DS Server machine. In this case, as the file resides in a remote Mainframe machine, is the only way t...

Hi, I'm working on 7.1 Server edition. Currently I do not have Complex Flat File stage in my client. Someone told that CFF stage is not available in 7.1 version Server Jobs. I would like to whether is it true or really CFF stage is available for 7.1 Server Jobs? If available, is it possible to insta...

I import the Cobol layout which is in a .txt format. This new metadata of the table definition has a 'Level Number' attribute for each columns. This is the way, its different from the other generic table definitions. This causes the problem in reading the source file correctly. Also the Cobol layout...

The Cobol file definition matches the Cobol file, thats correct. But when I import that table definition, I get details like level number in the metadata. Hope these kinds of metadata with level number can be recognized only by Complex Flat File stage and not by stages like FTP. Thats the reason I'm...

Hi, I'm using DS version 7.1. I need to read a Mainframe file from a Mainframe machine. I'm currently using FTP stage to read the data from the remote machine and then process it. For metadata to be used in the FTP stage, I import the copybook layout. But this does not read the file correctly. I nee...

Hi,

I would like to know whether is it possible to install DataStage Server 7.X in a Windows Vista Home Basic or a Home Premium edition. Or is it that we need atleast Windows Vista Business to install the DS Server.

Thanks.