Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I was wondering if it was possible to insert extra attributes into records when they are being loaded. The equivalent in a SQL pull would be like adding:
"TEXT" as record_type
to a select clause.
Hi,
Use the LOAD sentence to do that:
Customer:
LOAD CustID,
CustName,
'Customer' AS Type; // this is not in the SQL server
SQL SELECT CustID, CustName
FROM dbo.Customers;
Is that what you mean?
Miguel
Hi,
Use the LOAD sentence to do that:
Customer:
LOAD CustID,
CustName,
'Customer' AS Type; // this is not in the SQL server
SQL SELECT CustID, CustName
FROM dbo.Customers;
Is that what you mean?
Miguel
Single quotes! Of course. Thank you Miguel.