Search found 24 matches

by tini
Tue Sep 25, 2007 10:52 am
Forum: General
Topic: one more help please how to convert GMT to central time?
Replies: 10
Views: 5461

one more help please how to convert GMT to central time?

What is GMT?
and how can GMT convert to central time?
could someone please help.
Thanks
:oops:
by tini
Tue Sep 25, 2007 10:50 am
Forum: General
Topic: Help how to extract first field in a string (csv file)
Replies: 9
Views: 3441

thank you for your quite respond.
I wil try it.
thanks
tini
by tini
Tue Sep 25, 2007 3:16 am
Forum: General
Topic: Help how to extract first field in a string (csv file)
Replies: 9
Views: 3441

Help how to extract first field in a string (csv file)

I have a comma delimite csv file
the data looks like
"qqxx=ABCDFGFDR123,ddc=0,ss=SS,t=test",getline,cool,testing


I want extract ABCDFGFDR123 only.
how do I do that?
could someone hlep me please.
thanks
tini
by tini
Wed Aug 29, 2007 2:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Please help StringToTimestamp
Replies: 5
Views: 2574

ray.wurlod wrote:Version 4 parallel job? Really? :shock:
oop! version 7.1 not 4x.
sorry
by tini
Tue Aug 28, 2007 10:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Please help StringToTimestamp
Replies: 5
Views: 2574

Please help StringToTimestamp

I support to convert a string with varchar (17) and the data looks like 20070111124536777.
I need convert it to timestamp yyyy-mm-dd hh:nn:ss.
could someone help me please. Please give me the syntax too.
Thank you for your help
by tini
Thu Jun 19, 2003 6:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: question - DS 390
Replies: 1
Views: 979

question - DS 390

I am new in this form therefore I don&#8217;t know I post this msg in right place or not. Anyway my question is about DS390. In order for you to create a Mainframe job, you need to create a copybook in the mainframe and import it to Datastage right?
Thanks :oops:
by tini
Wed Jun 11, 2003 12:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: I need information for DS390
Replies: 2
Views: 1641

I need information for DS390

Please help I would like to know
What are advantages and disadvantages of DS390?
thanks

Thank you
by tini
Tue Jun 10, 2003 7:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: question for DS 390
Replies: 3
Views: 1235

thanks

Thank you
by tini
Mon Jun 09, 2003 7:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: question for DS 390
Replies: 3
Views: 1235

question for DS 390

Does everybody know when do we want to use DS 390 job instead of DS server job?
Thanks

Thank you