Search found 324 matches

by sachin1
Fri Aug 01, 2008 7:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can we use shared container as lookup in datastage server
Replies: 7
Views: 4190

Can we use shared container as lookup in datastage server

hello friends

my question is to confirm what i found, may be i am wrong ............

i think we cannot use shared container as lookup in datastage server jobs, if i am wrong please let me know more info on it.

thanks,
sachin.
by sachin1
Thu Jul 31, 2008 3:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: converting rows to columns
Replies: 3
Views: 1388

Re: converting rows to columns

please elaborate on what you want and what is your input..........
by sachin1
Mon Jul 28, 2008 6:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Case Insensitive Replace
Replies: 6
Views: 3542

Re: Case Insensitive Replace

EREPLACE may help
by sachin1
Mon Jul 28, 2008 6:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Deleting a job from designer
Replies: 4
Views: 1926

Re: Deleting a job from designer

Unlock the job from Datastage Administrator...............then you can do further analysis.
by sachin1
Wed Jul 23, 2008 6:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Log report
Replies: 7
Views: 2025

thanks a lot ArndW.
by sachin1
Wed Jul 23, 2008 3:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Log report
Replies: 7
Views: 2025

Please can you let us know the parameter.
by sachin1
Wed Jul 23, 2008 3:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Log report
Replies: 7
Views: 2025

the key field for hash file cannot have a length greater than equal to 768 characters.
by sachin1
Tue Jul 22, 2008 5:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Maximum stage variable and contraints
Replies: 2
Views: 1118

Maximum stage variable and contraints

Hello Friends,

i have below doubt,

1.Maximum number of stage variable, i can use in server job.


thanks in advance.
by sachin1
Tue Jul 22, 2008 3:36 am
Forum: General
Topic: Sequential File Stage file name
Replies: 5
Views: 1871

Sorry Ray but i have one doubt how can he execute 'ls' commandS when his OS is windows.
by sachin1
Mon Jul 21, 2008 7:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DStage scheduled jobs via Director are not running/triggered
Replies: 4
Views: 2374

Re: Datastage Schedule finishes but job does not get trigger

please provide more information regarding your scheduling and any message you get after scheduler runs ..............
by sachin1
Mon Jul 14, 2008 11:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Time
Replies: 5
Views: 1458

Re: Time

echo %time:~0,2%

C:\Documents and Settings\s1>echo %time%
22:32:38.65

for above time in 24 hour format, below commad gives the output as 22

C:\Documents and Settings\sabankar>echo %time:~0,2%
22
by sachin1
Sun Jul 13, 2008 2:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: can we install datastage 7.5.1A on windows vista
Replies: 1
Views: 1011

can we install datastage 7.5.1A on windows vista

hello friends please let me know can we install datastage server 7.5.1A on windows vista machine.


thanks a lot in advance.
by sachin1
Wed Jul 09, 2008 9:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: string to timestamp
Replies: 4
Views: 1415

Re: string to timestamp

your formatting is wrong i think please can you check my previous post
by sachin1
Wed Jul 09, 2008 8:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Column name value as parameter
Replies: 6
Views: 2345

please can you let us know how is the format of csv file column_name and its value, so that we can analyze your requirement to pass value for routine.
by sachin1
Wed Jul 09, 2008 8:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: string to timestamp
Replies: 4
Views: 1415

Re: string to timestamp

if you are inserting the value in database with column of sql type as timestamp then you need a format as 'YYYY-MM-DD HH24:MI:SS', do concatenation to get this format with proper time you want.

inputstring[1,4]:'-': inputstring[5,2]:'-':inputstring[7,2]:' ':'00:00:00'