DSXchange

Do you have your Excel columns setup as Text values? Within the ODBC Connection, can you wrap TO_CHAR, ROUND, or any of the ANSI SQL Functions around the input? I know that you can do this in an Oracle OCI stage, but I dont use ODBC Connections in DataStage. Malcolm Sinclair cc: Subject: Problems re...

This message and its contents are subject to the conditions set out at the end of this email ****************************************************************************** I am developing increasingly complex DataStage jobs to read XL spreadsheets and place data in Siebel (Oracle) tables. However I ...

Ray, I understand where you are coming from, but I think you are making some assumptions. What make you think the consultancy actually purchased a DataStage license? They could simply be doing development on the customers system. Nothing like on-the-job training... As for Ascential warning customers...

Chris, I was actually proposing a "black list" of ignorant and rude recruiters! No problem at all with this list or with Tools4DataStage Forum, the signal to noise ratio remains superbly high. However, I do believe that someone (Ascential?) needs to warn customers that minimal technical expertise ju...

I appreciate your point of view Ray. Its good to see people expressing their views. I guess another way of looking at it is that we live in a free world whereby *anyone* can compete for business. In the case of "lowest-tender code cutters", surely its a case of buyer beware. I certainly wouldnt proc...

A couple of replies to my earlier post on this, some off line. There were two issues I wanted to highlight, one the rudeness of the headhunter in not replying to enquiries (should there be a "black list"?) and the other the diminution of likelihood of success in DataStage projects, and consequent re...

You could define a file definition that has a single large field (say varchar 200) that is large enough to accept the full row width of your variable length records. The first transform stage could constrain the first 6 unwanted rows and only pass out the remaining rows to the next transform. This a...

Jennifer, Use @INROWNUM > 6 as your constraint on the transform following the FTP stage. The first 6 rows will go down the reject path if present, or the bit bucket if not. Alan > > From: "Jennifer Weise" > Date: 2002/11/20 Wed AM 11:05:36 EST > To: > Subject: Reading in a File > > I have an input f...

This is a topic for an orphaned message.

When im developing my jobs, i see no reason to use the director. I prefer to make a few changes, run the application and verify that it flows correctly intop the files/tables. (not using any debugger facilities like breakpoints etc) I seriously havent found any reason to use the director to execute ...

Im curious why you would be starting jobs via the Debugger except when you are... well, debugging? -craig tom.peter.nielsen@nordea.com 11/20/2002 06:14 AM Please respond to datastage-users To: datastage-users@oliver.com cc: Subject: Running from Director or Debugger Hi, (DS AIX 5.2) Is there any rea...

Hi, (DS AIX 5.2) Is there any reason to start program from the director instead of the debugger ? Sometimes we have some sharedcontainers that are locked, and usually by some "phantom"-processes. Could it be that DS locks the Sharedcontainers when we start the program from the debugger instead of th...

Hi Udo, Thanks for the advice. Those settings were correct. I think that the problem was not with the process metadata. I am trying to do a data lineage (find sources) on one of the tables in MetaStage and it keeps giving me an error that there are no paths for my specified criteria, although the pa...

Fellow listies, Remember a recent very short-lived posting seeking "six professionals for HCL" which closed the day after with the headhunter in question not bothering to respond to anyone who enquired? Well, heres a posting from Tools4DataStage/Forum from someone whose email address is @hcl, who pr...

ODBC stage also has "multiple rows from reference input" check box. ----- Original Message ----- From: Craig_Hulett@rsausa.com Date: Tue, 19 Nov 2002 06:40:49 -0700 To: Subject: RE: OCI error when migrating from 4 to 5 > Argh. That other stage is the UV stage. > > -craig -- _________________________...