DSXchange

Joe,

Generate a dummy header row using the Transformer. You can then use a Link Collector Stage to merge Header and Detail

Thanks

Sathya

Hi Shalini, You need to install db2 CLient on the Datastage Server. Have you done this? If you have the db2 client installed, are you able to connect to db2 database via Command Prompt? Remember you need to catalog your remote db2 Database on your Datastage Server for the connection to work Talk to...

It does with a Unix Script

ftp in binary-mode transfers files without trying to convert platform specific characters when moving a file from UNIX/Linux to Windows and vice versa, which ASCII-mode would do. I am aware about this. My FTP process is confined to Windows alone and I do not require the FTP to be set up as Binary. ...

Alright!!

Well, I already have a Unix Script in place as a workaround, but wanted to achieve this via the Datastage FTP Stage

Thanks for your time and help

Cheers!!!

Sathya

Thanks for the clarification Craig You can FTP the Excel file (in binary mode, as mentioned earlier) to your DataStage Server and then use ODBC connectivity to read the data from the Excel file. When I try your Binary approach with a Single Column and setting the Fixed Width Property set to Yes, the...

Ofcourse I am trying to Read a Remote Excel file and FTP that into my System How can I write an Excel File data into Sequential file as .xls? I need to read a Remote .xls Excel File and FTP that into my System as .xls Excel file using FTP Plug-in Stage I have tried reading single column before (as A...

Yes, I have tried that. That would require Fixed-Width Column property to be set to YES. The excel sheet I am trying to FTP has a defined metadata and not fixed width

Also, If i use the Binary option will it not FTP unreadable data?

Thanks

Sathya

Hello, I am trying to FTP a simple Excel file from a Remote path. I have configurated the settings correct. I say that, beacause if I FTP the Same Excel file as a CSV, it FTP's without any issues My job Design is: FTP Plug In --> ODBC (Excel Connection) I have verified the Excel table connectivity ...

The Answer to your above question is NO. Sequential file Stage cannot handle multiple input streams However, you can combine the multiple streams of data (multiple sequential files) into a single stream and feed that into the Sequential File Stage, provided they have consistent Metadata. In this way...

DB2 Bulk loader will use the DB2 Bulk Load Utility and logs the load statistics in the message path which you have provided in the property "Local Message File Name" under the Properties tab of the DB2 Bulk Loader Stage Can you get into the message file and look for any warnings/rejections...

Karthik, If you provide the File name from the Command Output it would be the list of all the files from the ls -m command. The reason you are using Start List Loop option with a Comma Delimeter is feed individual file names into the Sequential stage File name. You should use the Output from the Cou...

Can you please try the below approach Job Sequence Design: Exceute Commad Stage --> Start Loop --> Job Activity --> End Loop Execute Command Stage: Command Box: ls -m Parameter Box : #InputFileDirectory#sec* Start Loop Activity List Loop with Comma as Delimeter Derivation: #Execute_Command_0.$Comman...

As per Craig it is the Field Marks which is causing your condition to fail. Strip the Field Marks in the Nested Condtion Stage using the below Derivation:

Convert(@FM,"", Activity.$CommandOutput ) = 'all_v1'

Let me know if this works.

Thanks

Sathya

When I sent in the message, it was still not Marked as Resolved.

But now it is!! :D