DSXchange

hi all, am getting the following error while executing a job.Could anyone help me out? "DataStage Job 298 Phantom 5958 Program "JOB.1504133597.DT.147051563.TRANS3": Line 429, Variable previously undefined. Zero length string used. DataStage Phantom Finished" Your time is highly ...

ray.wurlod wrote:Specify the delimiter as 009.

Read the Help (press F1 while in the Format page) to see how you specify non-printing delimiter characters. ...

thnx ray

For one table, or even if there is more than one table but the table names are unambiguous, you don't need to quality the column name with a table name. On the Columns tab simply clear the Derivation ... Consider if A is my source DB and i've parameterized that as #DB# then the #DB# shud be reflect...

hi all, Am having Database as a source. I got to parameterize the TABLE NAME in that DB. After importing the required table(in both table name field and as well as the meta data of the table in the column tab) and i gave Generated SQL query. I've parameterized the table name and it got reflected on...

ray.wurlod wrote:Or tab-delimited. Tabs in data are fairly rare, since tab in Windows applications moves one to the next field. ...

Ray
as u said i've changed the format to tab delimited and stored it and how can i give the delimiter value in Datastage?Ur time is highly appreciated.

Thanx..

Use psv. Pipe seperated values. Now Pipe will be the field delimiter. ... I can able to get the data from XLS sheet into PSV format provided if am supposed to extract the data from MS Access(as of my knowledge).How can i implemnt the same in an ordinary XLS sheet because i haven't found the PSV for...

kumar_s wrote:Use psv. Pipe seperated values. Now Pipe will be the field delimiter. ...

Thanks kumar...I've used PSV and got the soln. Thanks for ur time

hi all, Am having excel sheet as the source for my job. I've saved that XLS sheet in CSV format. Since it is a CSV file, i gave comma(,) as a delimiter. But one of my address field column looks like this: 170,Pine Street,New York. DS taking this as three diff columns and am not getting the right ou...

hi all, Am extracting the data from a database and then put in a sequential file of UNIX style.At that time the data at source (database) and the target (sequential file) are the same.While i tried to write the data into another sequential file of DOS style format from the sequential file of UNIX st...

Find out, perhaps by using the LIST.READU command, who has the job open. Ask them nicely to close it. If the lock is owned by a redundant process, use dsdlockd -p command to clean up. ... ray, That problem aforementioned will be rectified by closing the job in the director itself right?And could u ...

When i tried to import job through manager to TEST environment, i got the below error. "Cannot get exclusive access to job 'jobname'". How can i rectfy this. Can you please let me know whats happening in the backend hi, someone would've opened the job in the Director so better ask them to...

ray.wurlod wrote:You may or may not require a surrogate key. A Type 4 SCD, for example, maintains a separate history table, and that can be keyed by the business key and an expiry date.

As a general rule, where th ...

could u pls. wat do do u man by business key?

ray.wurlod wrote:You may or may not require a surrogate key. A Type 4 SCD, for example, maintains a separate history table, and that can be keyed by the business key and an expiry date.

As a general rule, where th ...

could u pls. wat do do u man by business key?

Hai Everyone,

Example:

Filed name: POLICYNO
Value of POLICYNO: 1234, 1234-01,1234-02,342345,464556-02.

Is there is any Substring function exist in Datastage to get the value before "-" in the above said example.

Thanks in advance....

Hai Everyone, I am requiring a solution for this problem. I got a field name as "POLICYNO", the content of the field resembles like 1234, 1234-01, 1234-02, 236789, 45467, 45456-03.5645.45456-02, 45456-01, 45456. In the above example 1234 is the primary record, and the 1234-01, 1234-02 are ...