Use convert function
convert('.','',columnname)
Hope this will help you
Search found 5 matches
- Thu Feb 26, 2015 7:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp to String Conversion with microseconds
- Replies: 3
- Views: 3847
- Sun Jun 10, 2012 11:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: VARCHAR TO BIGINT
- Replies: 7
- Views: 5507
Re: VARCHAR TO BIGINT
Conversion is not required for your senario.
we can't convert integer to varchar.
we can't convert integer to varchar.
- Thu Jun 07, 2012 2:26 am
- Forum: General
- Topic: Reading Datastage logs from Unix
- Replies: 5
- Views: 3967
Re: Reading Datastage logs from Unix
I Think this is not possible.
if i am mistake please correct me
if i am mistake please correct me
- Mon Mar 26, 2012 9:11 pm
- Forum: General
- Topic: what is diferrence between 8.0 and 8.5
- Replies: 2
- Views: 1404
what is diferrence between 8.0 and 8.5
what is diferrence between 8.0 and 8.5
- Thu May 05, 2011 5:58 am
- Forum: General
- Topic: Not able tosee the Menu bar ( File,Edit,View,Tools...)
- Replies: 2
- Views: 1956
Re: Not able tosee the Menu bar ( File,Edit,View,Tools...)
Hi Siva,
Please go to the RUN-> type 'regedit' then open the registry
Then go to the HKEY_CURRENT_USER Folder ->softwares folder->DSDesign Folder and then remove the all folders except Menu_Default~!@#$#$%^ ,Menu_Default~!@#$#$%^_RecentlyUsedSubmenuItems.
Please go to the RUN-> type 'regedit' then open the registry
Then go to the HKEY_CURRENT_USER Folder ->softwares folder->DSDesign Folder and then remove the all folders except Menu_Default~!@#$#$%^ ,Menu_Default~!@#$#$%^_RecentlyUsedSubmenuItems.