DSXchange

What is the delimiter for your file? You have many such records. Get the n-1 or n+1 record's primary key, and look into the the database, check if you have any special character in columns of the nth records.

Try to check if its an issue with the copybook. Try to edit the copy book and eliminate columns one by one. Make sure you maintaining the total length of the file.

Create two script, one to encrypt and other to decrypt. The encryption script will be passed with password as a parameter and will be called once at each insance in change of password. And it will produce a file at some specific directory with a encrypted password in it. Decrypt script which ought t...

Try to create a userdefined variable PWD and point to your project directory or '.'.

Using transformer, you can create columns with empty strings to match the metadata. Or use script for the same purpose. 'Cat' the two files.

If any job under Jobsequence exceeds 50 warining or the warning apear in the JobSequence log, exceeds 50 the abort is raised.

What is your lookup data stage. You need to have a seperate flow in datastage to update the information of the static file. If the inputs are from third party, or web oriented, you need to capture it and place it in a common folder with a predefined filename, either in flatfile or in any database. S...

One option that we had done is as follows.
Pass the necessary parameters, and call a shell script which inturns loads the data into the table. The same shell will read the encrypted password stored in a file and decrypt during runtime and pass it to the database.

"Output file full" and "Unable to allocate communication resources" should tell you the reason.
Check your scratch space.

PX Job??
DS_JOBS will give just the information about the job.
Do a reset, find "From Previous log..." event. It might give you more information.

Hi Anee, Where do you see the '1'. Is it in view data or in output flat file?
What if you concatinate with other character?
Are you trying with any stage variable?

You should not urge people to answer, But the same time you should provide the necessary log information to others to investigate.

Call the stored procedure in input tab, write into a intermediate table, and select the table in output tab.

Is the metadata loaded and the metadata of the selected column list matches?

If there is no relationship between two table, how can you merge two table without cartision product.
Can you explain your need with some example?