Search found 20 matches
- Wed Aug 15, 2007 10:22 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: char(176) function to column as value
- Replies: 1
- Views: 1820
char(176) function to column as value
Hi , In one of existing datastage job ,for one coulmn say subfunction they have taken the value as char(176) which in the table holds the values of ascii characters after loading. Plesae see the below query : INSERT INTO T17020_TXN_CODE_DIM ( TXN_CODE_KEY, TXN_CODE, TXN_SUB_FUNCTION, TXN_CODE_FULL, ...
- Wed Aug 08, 2007 10:57 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: row count in hash file
- Replies: 6
- Views: 2729
row count in hash file
Hi ,
Can we ger row count in hash file.can i know how can we do that?
Can we ger row count in hash file.can i know how can we do that?
- Sun Aug 05, 2007 8:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: shell script execution on datastage server
- Replies: 4
- Views: 3029
shell script execution on datastage server
Hi I have my datastage server on windows environment and i need to get file from unix server which is remote. I need to execute the shell script in datastage job using execsh where datastage server is in windows environment. is there any alternative for this to run the unix commands which are in tha...
- Sun Aug 05, 2007 8:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ftp script
- Replies: 9
- Views: 4295
- Sun Aug 05, 2007 8:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: gunzip usage
- Replies: 13
- Views: 5463
- Sat Aug 04, 2007 11:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ftp script
- Replies: 9
- Views: 4295
Hi I have my datastage server on windows environment and i need to get file from unix server which is remote. I need to execute the shell script in datastage job using execsh where datastage server is in windows environment. Is it possible to this. or is there any alternative for this to run the uni...
- Sat Aug 04, 2007 10:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: gunzip usage
- Replies: 13
- Views: 5463
- Sat Aug 04, 2007 10:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: gunzip usage
- Replies: 13
- Views: 5463
- Fri Aug 03, 2007 11:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: gunzip usage
- Replies: 13
- Views: 5463
- Fri Aug 03, 2007 11:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: gunzip usage
- Replies: 13
- Views: 5463
Hi arnw, Still i am getting same error. In the above post i am giving the command ls -rt1 | tail -1which will givesthe output Jul07.gz which is a zip file. the same .gz file i am paasing to gunzip command using | in unix box. i am unable to understand why am i getting this error even i am passing th...
- Fri Aug 03, 2007 8:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: gunzip usage
- Replies: 13
- Views: 5463
gunzip usage
Hi I am getting the following error while i am trying to send the oputput of one command to another. The command is : ls-rt1|tail -1| gunzip here ls -rt1 |tail -1 is avle to give the out put with all .GZ files i.e total 74105 -rw-r--r-- 1 testapp netx 7337398 Oct 09 2006 Sep06.09Oct06_11:58.gz -rw-r...
- Thu Aug 02, 2007 11:14 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: accessing zip files
- Replies: 15
- Views: 5087
- Thu Aug 02, 2007 10:13 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: accessing zip files
- Replies: 15
- Views: 5087
- Thu Aug 02, 2007 9:13 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: accessing zip files
- Replies: 15
- Views: 5087
Hi I have the folder path like this in unxi server: /home/users/ftptci This path is having the files like May2007.gz,June2007.gz,Jul2007.gz as well other files say 58.gz ,xxxx.gz . Out of these files which are different names along with monthly file names as mentioned above. I need to capture the la...
- Thu Aug 02, 2007 2:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: accessing zip files
- Replies: 15
- Views: 5087