Search found 53 matches

by shrinivas
Thu Feb 22, 2007 12:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Validation of a time column
Replies: 12
Views: 2629

************************************************************************ * Input Argument: Input : Input Time * * Input format HH:MM:SS ************************************************************************* Input = Trim(INTIME) Output=1 If Len(Input) = 8 Then Hr = Field(Input,":",1) Mn ...
by shrinivas
Thu Feb 22, 2007 12:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Validation of a time column
Replies: 12
Views: 2629

No change Kumar , I am getting the same result. I tried in other way , Just splitting the input into Hour, Min and Secs and checking it individualy for 0<=Hour < 24 . 0<=Min < 60 , simillarly for Secs, But the problem here is , When I pass Input as for example 00:/9:10, the invalid value here is &qu...
by shrinivas
Wed Feb 21, 2007 11:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Validation of a time column
Replies: 12
Views: 2629

Validation of a time column

Hi Gurus, I need to validate few input columns having data in Time , The format of the columns are HH:MM:SS. My requirement is just to validate the input time . I worte a routine for it using Iconv(Input,"MTS") and Status() function but when I pass for Example 25:60:60, the status function...
by shrinivas
Wed Feb 14, 2007 4:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file thru FTP
Replies: 8
Views: 1506

Yes, you right default port is 23. There are two Windows server . One is remote server where I have to delete files thru FTP. One is my datastage server which is a development environment. When my project goes in to production, datastage server will change in to Unix. I have to develope jobs as such...
by shrinivas
Wed Feb 14, 2007 4:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file thru FTP
Replies: 8
Views: 1506

the remote server is Windows and the target server is Unix
by shrinivas
Wed Feb 14, 2007 4:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file thru FTP
Replies: 8
Views: 1506

One more strange thing is happening . I am getting an log stating "Unable to connect to telnet socket on '111.111.111.11'" . where '111.111.111.11 is my Source server IP. After the three attempts to connect its giving warning as " unable to execute Telnet command 'Telnet After Command...
by shrinivas
Wed Feb 14, 2007 3:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file thru FTP
Replies: 8
Views: 1506

I put on tracing . The log I found is "unable to execute Telnet command 'Telnet After Command'' . What I am doing is ,I am writing the command in the telnet After command as "delete Source_Folder\test123.txt" where Source_Folder\test123.txt is my source file path. The problem I could ...
by shrinivas
Tue Feb 13, 2007 11:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete file thru FTP
Replies: 8
Views: 1506

Delete file thru FTP

Hi DS guru's, I am trying hard to delete files thru FTP. I am FTPing files from Windows server to Unix server and need to delete files after FTP from windows server. Think we can delete files thru Telnet after command in FTP stage . But in my case its not working. I think I am missing some thing. Ne...