DSXchange

If you're just moving a file around don't use the FTP stage use command line FTP or SCP. That being said, a LAN is a physical server. You need the IP address of that server and a valid userid with credentials.

The concept of pipeline parallelism means that the data is flowing across all stages. In your diagram, I don't see why the data won't be coming out of the source database while other data is already loading into the database. The exception would be if you introduced synchronization stages that cause...

There is no internal DS Timestamp, only Date and Time. Try setting your metadata on the column to VARCHAR and seeing if it will load. Also, if using auto-generated SQL, look at the SQL DataStage writes when th data type is Timestamp. If it doesn't add any DB specific conversion functions, then it's ...

When it came out in 5.0 I was sooo excited. I never got it work right and also experienced the hangings. I have shunned it as well and not revisited it since.

Welcome aboard! Why are you posting in the MetaData forum? This doesn't seem like a MetaStage question. To answer the question, your data is too big for the column. if the data type and size of the target column is VARCHAR(20), do you think you should be able to put more than 20 characters into that...

You're just simplifying the administration. For small files performance won't be that bad, but for big files you'll see it's just like FTP. For big files, compression and high-performance ftp or scp followed by local decompression can be faster, but it's more programming. I don't mind the compress, ...

Thanks, that simple comma changes the tone.

It means the client was not installed as administrator, you'll need to get that client folder opened up in permissions.

Sure, just write a SQL script and have DS execute it.

ray.wurlod wrote:You can do it in SQL with SQL functions, not with DataStage functions as Ken indicated.

You slight me sir I said no such thing. Please re-read my post.

The first question to be answered in performance tuning is: Are all available processing resources being utilized? In other words, if all of your cpus are busy for one hour, where would you go to get more processing completed? There's no cpu time available to do more work. So, use your unix environm...

If the expected output is 10 rows, then your problem is now the time it takes to fetch and move the data out of the database, but the time to construct the result set. Your solution is to tune the SQL. If the expected output is 100000000 rows, then your problem is probably the fact you're moving a l...

Welcome aboard. If your database supports creating functions, that's where you need to do it. DS Functions are only good inside DS. When DS issues the SQL to the souce/target database the SQL is in the hands of the database, any use of functions in the SQL must be valid within the database itself. I...

And not using EXPORT causes your changes to be just an exercise in typing.

Where are your EXPORT statements after you set the environment variables? If you look at the dsenv file, you'll see you didn't do it right.