DSXchange

Hi, I would like to list the jobs/sequencers under the folders of my project. For example, I have MYPROJECT project and folders FOLDER1, FOLDER2, FOLDER3, FOLDER4 and FOLDER5. I would like to have an output which will give me the folder name and the jobs/sequencers under it: FOLDER1: Job1a Job1b Job...

Hmm, ok.. but I need to feed in the record (just one column) to an Execute Command stage. For instance, I have 3 records with values:
TOM
DICK
HARRY

I need to pass each as parameter to an Execute Command stage. How do I make a parameter equal to the row value?

Hi, I am using Server edition. I have a database table which I query. Say the query returns 5 records, I need to process each record through a job. I believe I need to use a Loop here. But I do not know how to do that. I am new to DS so if you can just tell me in detail how to proceed. Thanks in adv...

Hi, My company uses Server edition (Ascential DataStage v7.5.1). I would like to go for DataStage certification. However, am seeing only exams for Enterprise edition. Is there any certification for "Server" edition only? If not, any advise which exam is the closest I can get knowing only S...

Hi,
When I run my job, it throws an error: How do I fix this??
thanks in advance..

Oooops, got it. It's not under the Properties Window. There's an NLS button.

Thanks but I am using Server edition and I do not see such NLS tab.

Hi,
How do I set the Project Default NLS?
Thanks in advance.

Hi All,

We plan to upgrade our DataStage from Server edition to Enterprise edition (formerly PArallel Extender). I would like some input on:
- how it can be done (very important)
- possibility of such
- benefits
- drawbacks
- (anything else?)

Thanks in advance..

One error is: Abnormal termination of stage VRV_ORDERS_DRS..Transformer_24 detected Or sometimes: ORDERS_STG..Transformer_24: ORA-01830: date format picture ends before converting entire input string -- probably because the SQL Server format is 'YYYY-MM-DD 00:00:00.000' and the Oracle tries to conve...

Hi, I have to read from SQL Server database a string which has a format 'MM/DD/YYYY HH:MI:SS PM', and save them as Date datatype in Oracle. How do I do that? I got errors when I tried the following: 1. SQL Server as Varchar - Oracle as Timestamp and used TO_DATE(:138, 'MM/DD/YYYY HH:MI:SS PM') durin...

Hi,
How will I know when a job or sequencer is last updated or created? Is there a DS table I can query for this?

Thanks in advance.

hi Craig,

It did load the columns with newline characters correctly - however, it failed for those which have tabs. Do you think it will help if I change my delimiter?

Thanks..

Hi Chulett,
I made my datafile to have fixed widths, but I am getting "column unexpectedly ended by EOR".
All I need is to be able to load a field value that has tabs and newline characters inside it. I hope anyone can help me figure out how to do it..
Thanks..

I'm sorry but I'm no pro in DS. How do I do that? Besides, how will that handle the tabs (which are my field delimiters) inside that email_msg field? Hence, even if I have this **ROW**, because of the tabs inside that field, i may map incorrect column mappings..