DSXchange

It does not affect the performace directly, but yes, there are case where the warning will be generated for each row, which may be millions together, which makes the log file to grow very huge. Which may again lead to project directory to run out of space. Which inturn may affect all other project i...

You can CALL the storedprocedure without even importing into to Datastage.
You can use UserDefined query as {CALL SP} or with an argument passed in it as {CALL SP(?)}.

Have you tried Iconv("Link.Input", "DYMD[2,2,2]")?
Or you can even try the same previous option by concatinating "/" in middle. StageVariable = Link.Input[1,2]:"/":Link.Input[3,2]:"/":Link.Input[5,2], and use this stage variable for conversion.

You can also try with combination of "MCN" and "MC/N" in Iconv /Oconv.

Where do you get this informatin that "that process Id is unavailable."? If this appears while you login to Cleanup Resource, neglect it. Did you followed the steps that mentioned. What message you get when you open you job now? If you are able to see the job name in the item id under 'Locks', note ...

But it complains that the source is in MM/DD/YY format. What is your target stage?
Use to convert it into Date fromate from String. If it is a database stage, you can use To_date() that avaialble in database SQL statement.

Do you see the PID still in Locks under Cleanup resources?
Do you see the PID in unix?
What is the exact message it gives you?

Hi Krishna,
What is the format of the string and what is error you getting?
Is it in mmddyy format or some kind of julian date or something like date since..?

Edward's option should work, untill the jobs are recompiled to create the executables.

Hi Vinod, This has been discussed several times. User dsadm, login to DS directory - CleanUp Resources. Under 'Locks', you may find the jobs name. Select the item under 'Process' corresponding to that PID. Now select Go by process in Locks and ReleaseAll locks. Else you can go for unix Kill or DS.TO...

Not all stages use scratch disk space extensivly. Sometimes it may not use at all, other than buffering operation. So it also depends on the operators that involved in the Job.

Hi crsoza ,
Welcome Aboard. You may need to give us more detail on how the job is been called, and full error message, and transformation if involved any.

Ask your DBA to connect to a database from a command prompt without using user id and password (the way he wants from datastage). You can follow the same process.

If the data is not sorted, you may need to include even a sort stage. It again depends on the number of duplicated the input contain, and the data of the lookup (either its a sparse or Lookup fileset). If it is a lookupfileset, and if you have less records per group (duplicates) and with simple tran...

That is ok to remove all the leading 0's from STREET_NUMBER. If have any warning, post it.