Search found 312 matches

by Marley777
Wed Nov 12, 2008 12:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs are schedule, but unscheduled in director
Replies: 9
Views: 2186

Hi - i first wanted to say thanks for helpin me.

When I loggin as the user that scheduled the jobs and run this command on the command line crontab -l it sends me back to the command prompt $
by Marley777
Wed Nov 12, 2008 12:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs are schedule, but unscheduled in director
Replies: 9
Views: 2186

Hi - i first wanted to say thanks for helpin me.

When I loggin as the user that scheduled the jobs and run this command on the command line crontab -l it sends me back to the command prompt $
by Marley777
Wed Nov 12, 2008 12:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs are schedule, but unscheduled in director
Replies: 9
Views: 2186

also wanted to add that we only use one userid on the prod box. we know what user scheduled the jobs, but can't see the schedule using the correct userid. We can't see the schedule using any id.
by Marley777
Wed Nov 12, 2008 11:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs are schedule, but unscheduled in director
Replies: 9
Views: 2186

Jobs are schedule, but unscheduled in director

We know the jobs are still scheduled, and we used to be able to see schedule information in director. We no longer can see the schedule information in DS Director. The jobs still run as scheduled. How can we correct this problem so that we can see the schedule again in director? thanks for your help...
by Marley777
Sat Sep 13, 2008 6:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: set read only jobs to not read only
Replies: 7
Views: 2762

I use to have a set of dir I would have to enter into before I use the command UPDATE DS_JOBS SET READONLY = 'NRO' WHERE NAME = '<<JobName>>';. I just can't remember where to go to run the command. Thx.

:oops:
by Marley777
Sat Sep 13, 2008 5:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: set read only jobs to not read only
Replies: 7
Views: 2762

set read only jobs to not read only

How do I change jobs from read only to not read only. I know I can use DS_JOBS set READONLY="NRO" but lost my notes. I know this can also be done in the dsx file, but want to change in the tbl. Thx.
by Marley777
Thu Jun 26, 2008 6:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SMTP mail Server name in a sequencer job.
Replies: 1
Views: 1697

SMTP mail Server name in a sequencer job.

i don't specify a SMTP Mail server name, but my sequencer jobs send e-mail with no issues. How do I know what relay server is being used? We need to change from INET80 to something else, but I can't see where i need to change this? I'm wondering if it's defaulting to something under the covers in th...
by Marley777
Tue Feb 26, 2008 9:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Have you a trick for : Field not like list of value
Replies: 13
Views: 7363

Thanks Chulett, I will give this a try. :lol:
by Marley777
Tue Feb 26, 2008 9:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Have you a trick for : Field not like list of value
Replies: 13
Views: 7363

Index("Word01,Word02,Word03,Word04,",ds1.field:','

Hi everyone, thanks for reading and your suggestions. If I could get this code posted by Arndw to work; it may be all I need. Arndw's version - Index("Word01,Word02,Word03,Word04,",ds1.field:',') my version - Index("Agency,Agents,Bank,Inc,",input.field:',') I get an error asking ...
by Marley777
Mon Feb 25, 2008 12:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Have you a trick for : Field not like list of value
Replies: 13
Views: 7363

Index("Word01,Word02,Word03,Word04,",ds1.field:','

Hi, in regards to Index("Word01,Word02,Word03,Word04,",ds1.field:',') I cannot get this to work. I use the same format, but get a transformr error(not enough arguments to function index). Was wondering if someone else was able to get a flavor of this code to work? Here is what my code look...
by Marley777
Fri Feb 22, 2008 1:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: split string field based on the occurrence of a string
Replies: 14
Views: 22790

Hi, thanks for your help so far. Everything seems to be working. However there is a new piece to the puzzel. I have been given a spreadsheet that contains hundreds of values (BANK, AGENCY, AGENCY, ACADEMY). I have to know if the name I'm parsing cotains any of these values. I know I can use Index(cl...
by Marley777
Thu Feb 07, 2008 4:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Failure during execution of operator logic. [api/operator_re
Replies: 1
Views: 1418

Failure during execution of operator logic. [api/operator_re

Hi, has anyone seen this error before? Do you know what causes this kind of error? Failure during execution of operator logic. [api/operator_rep.C:324] I also get this warning just before the failure warning. Are the messages related. TRN_NameAddrData,0: The current soft limit on the data segment (h...
by Marley777
Thu Jan 31, 2008 11:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: split string field based on the occurrence of a string
Replies: 14
Views: 22790

name parsing

Hi Ray, I looked at your example. Have a question. How can I expand on you logic to handle the following scenario. I can have more than just 'DBA'. I can have 'C/O' or 'T/A' etc... about ten possibilities. Whenever I encounter one of these ten values the field must be parsed into two fields. I'm hop...
by Marley777
Thu Jan 31, 2008 11:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: split string field based on the occurrence of a string
Replies: 14
Views: 22790

name parsing

Hi Ray, I looked at your example. Have a question. How can I expand on you logic to handle the following scenario. I can have more than just 'DBA'. I can have 'C/O' or 'T/A' etc... about ten possibilities. Whenever I encounter one of these ten values the field must be parsed into two fields. I'm hop...
by Marley777
Tue Jan 29, 2008 2:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: split string field based on the occurrence of a string
Replies: 14
Views: 22790

Hi, I have lots of records on one file that I'm reading into a transformer. Based on one column one record can become two records. We want to seperate names. If 2 records had DBA somewhere in the name field we would end up with 4 records. BOB MARLEY DBA JAMAICA ISLAND TOURS ZIGGY MARLEY DBA ZIGGY'S ...