DSXchange

You can look at the course catalogue

Check for any changes in the uvodbc.config file in the project and the ODBC data source definitions.

Describe your job design. What stage are you using to put the rows into the target?
Post any error message that's logged in the job log.

The Ascential/IBM classes are streamed - there are versions of DataStage Essentials for both server and parallel editions. Similarly there are versions of Advanced DataStage. Ascential had an agency in Chennai that can deliver training. Presumably you should now be asking IBM India. But they have no...

If you're using Version Control, put them in versioned folders. Otherwise, the scripts using cp or rcp or ftp (etc.) and the jobs using export/import. Hashed files are trickier - a recursive cp will work, but you may find it easier to re-create them once the jobs are in place. You can do this by val...

Are you putting the job parameter reference (#paramname#) in the Command field or the Parameters field?

I seem to recall that it's only resolved if it's in the Parameters field.

All! It's surely an easy change to each GUI. Don't want to have to switch to grid style just to insert parameters. Parameters for partial references are already catered for in the parallel job stages; you can, for example, insert a parameter for the directory then type in a slash and the file name.

You WILL need to talk to your DBA because you won't have privilege to issue the GRANT.

Welcome aboard! :D Read the message again. You have to have administrator rights to release locks owned by other processes. Administrators are - theoretically at least - trained to recognize when it's safe to release locks and when it's unsafe. If it wasn't needed to lock objects for editing/monitor...

Welcome aboard! :D

Initially the job was working fine, but now I am getting this error.

Tell us what changed. "Nothing" is not the correct answer.

Welcome aboard! :D

Check for unexpected NULL in your source data.

Assuming that it's coming in accurately as Char(255) you certainly can.

Can you import table definitions?

Check that you have requisite SELECT priveleges to the system tables.

Hi, We have numerous prod jobs which makes the log full. We have a scenario where we want to know which job has created the particular log. Is there is any routine/ utility which can give the tell which log file is been created by which job. Thanks in advance..... Regards The Director client does t...

That's very close to hijacking the thread! Set up the ODBC stage, with the DSN filled in. Then click GetSQLInfo. This goes out to the DSN and retrieves the SQL quote character (which is "`" for MS Access) and delimiter character. So access needs queries like select `table`.`col1`, `table`.`col2` fro...