Search found 5 matches

by dang
Wed Oct 03, 2007 6:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Why am I getting an extra double quotes for scheduled job
Replies: 5
Views: 1907

Thanks ArndW and chulett. I used that command and it worked fine running manually. Next month will be the test when it runs as a scheduled job. I will mark this as resolved.

Dan
by dang
Tue Oct 02, 2007 12:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Why am I getting an extra double quotes for scheduled job
Replies: 5
Views: 1907

The filename is hardcoded "REGION.CSV" The parameters I am passing are SOME_PATH and BASE_PATH
by dang
Tue Oct 02, 2007 8:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Why am I getting an extra double quotes for scheduled job
Replies: 5
Views: 1907

Why am I getting an extra double quotes for scheduled job

Windows Server 2003 SP2 Datastage 7.5 In a routine activity sequence I have the following command: "copy " : Char(34) : SOME_PATH : "\DataIn\REGION.CSV " : Char(34) : " " : Char(34) :BASE_PATH : "\data_in\user\REGION.CSV" : Char(34) : " /Y /V" I hav...
by dang
Wed Aug 30, 2006 9:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP flat file to mainframe as PS
Replies: 1
Views: 1416

Here is what we use to ftp from Windows to the mainframe. In a transformer step, we build the ftp commands using ETL parameters as follows putting the commands into a text file with a suffix of FTP: "open xxxxxx" : Char(13) : Char(10) : "user" : Char(13) : Char(10) : MAINFRAME_FT...
by dang
Mon Aug 21, 2006 8:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Remote Command Tools?
Replies: 9
Views: 5183

Hi Greg,
Are you familiar with the "Routine Activity" sequence? We use this to issue commands on other servers. We also use it to FTP JCL to the mainframe JES2 system to submit JCL.

Good luck,
Dan